For more infomation >> [Ballia News] Minister spends Rs 500 crore scam in education department / THE NEWS INDIA - Duration: 4:00. 
we will now begin
Step 1. Creating the source document, which is a mailing list in
Microsoft excel each column must have a heading
Such as
Column, a first name column b last, name column c
Your address and column d the city state and zip
You must always save this
Document to the desktop a, jump drive or folder on the desktop
This document. Is going to be needed, when we go to microsoft word to prepare the document
For the mail merge and to print the labels
Now, we move on step two.
Which is preparing the word document for the mail merge and the labels.We click on mailings from the menu bar
Then click start mail merge
We will choose labels from the start mail merge dialog box
Your label options dialog box will appear
You check for your printer information. Make sure it's on continuous feed printers but it's good for now
You look for your label information, your vendors, what's showing now is avery a4 and a5.
And when you look at the dialog, box there are several different kinds of labels
Vendors that you can use. right now we'll use avery a4 and a5
And when you get your label box, make sure you look on the box and you look
For your label product number.In this case, we're going to be using
product, number 5160
And then you say, ok.
When your word document comes up it shows you the size
that your labels are going to be
Now you go back to mailings and you click on select recipients. Here is where we're going to go back to
Our desktop and retrieve our
Mailing list where our list is. The dialog, box has options that says type a new list
Choose from outlook contacts or use an existing list, we're going to choose use an existing list
Your A select data source dialog box appears and you go to where you saved it, in this case
we saved our document on the desktop and i
named it
Mailing list, it is an excel file, here it is, double click
And the select table dialog box opens and you make sure that the name of that
Tab is in the table and then you click on ok.
the Word Document takes you to where we are going to put the records so you go back to mailings
This is where we're gonna take advantage of those column headings. We're gonna insert merge field
And what you'll see is the first name heading last
Name heading the address and the city state and zip heading
We'll go ahead and and we'll put in the first one which is first name
Then go back to insert merge field
click last name
Go back to insert mail merge field click on address
Go back to insert merge field and click on city state and zip
and before you've
complete you
Want to do cleanup on your records so make sure that but there's a space between first
And last name make sure that your address is on a
Separate line as, well as
Your city state and your zip and while you're in this screen
You want to go ahead and do any formatting that you want to do your label
So you highlight the label
And then click home
You may want to change the font style to new times roman
change the font size to 12
I Like to center my labels
Sometimes i like to change the color of my labels as well. So I will just pick a pretty blue
And this is just an example of what they'll look like
Then you click mailings again, and you'll go over to where it says update
Labels and so it does the same thing to all the labels that you have in the mailing list
And in step three you want to preview
And then print your perfect labels so you go back up here to mailings and
you click on
Preview results and what you'll see are the actual names that are in your mailing list
and then you'll
Go here to where it says finish and merge so this is where you're gonna
Print the information that you see on the screen
And you have options where you can go back and edit
Individual documents. You can print the documents which we are going to do and
Send email messages so we'll go ahead and click on print documents
Your merge to the printer dialog box appears. once again you have options to print all the labels
The current label that you would be looking at or print from a certain range like
The first labels to the fifth label and then you click ok.
Of course your print dialog box comes up. you want to make sure that your
Correct printer is printing. I know
This is says printing two documents waiting that's because i'm not actually printing. make
sure that your page range
Is selected. I've selected all. Make sure you tell it what to print, all pages in the range that you've selected
Pages per sheet one, and whether or not if you're going to scale or not and then click, ok.
and
These are perfect labels ready to print and put on envelopes
or letters.
Đăng ký:
Đăng Nhận xét (Atom)
Không có nhận xét nào:
Đăng nhận xét