|
Step One - Set Up Your Data For a Mail Merge:
-
Import
into Excel. See Data Import
Instructions for Excel. If you already have imported
into Excel, go to next step.
-
Delete
the unwanted data and the blank fields which will not be
included in your merged document, such as qualifier fields,
phone numbers, etc.
-
If
there is not a header row containing column titles on your
spreadsheet, insert one, see below.
| A |
B |
C
|
D
|
E
|
| 1
|
First Name |
Last Name |
Address
|
City |
-
Save
your file, click File Menu, click Save As, change "Save
as type" to Text File (tab delimited).
-
When
gray box pops up ("...may contain features..."),
click YES.
-
Close
Excel - DO NOT save changes.
Step Two - Create a Data Source / Table:
-
Start
Word.
-
Open
the text file you created in Step One.
-
Hit
Ctrl A (this selects all the data in the spreadsheet).
-
With
the data highlighted, click Table Menu, click Convert, click Text to
Table.
-
Under
"Separate text at", select "Tabs", click
OK (AutoFit behavior should be set at Fixed column width).
-
Save
your file, click File Menu, click Save As, change "Save
as type" to Word Document (.doc).
-
Close
document.
Step
Three - Mail Merge to Mailing Labels:
-
Create
new Word document.
-
Click
Tools Menu.
-
Click
Mail Merge, click Create, click Mailing Labels.
-
Click
Active Window.
-
Click
Get Data, click Open Data Source.
-
Locate
the Word file you created in Step Two.
-
Click
Set Up Main Document.
-
Select
Avery standard, 5160-Address, click OK.
Step Four - Set Up Label Structure:
-
Click
on Insert Merge Field.
-
Click
on desired fields for labels, insert any spaces, commas, or
returns where necessary.
-
Click
OK, click Merge, click Merge.
-
Save
your work, your labels are now ready to print.
Optional Step - Change Case:
-
Highlight
the desired data, click Format Menu.
-
Click
Change Case, choose from these selections:
-
Sentence
case: the first letter of the first word in selected
sentences is capitalized.
-
lowercase:
changes selected text to lowercase letters.
-
UPPERCASE:
changes selected text to uppercase letters.
-
Title
Case: the first letter of every word is capitalized.
-
Toggle
Case: changes uppercase letters to lowercase letters,
and vice versa.
|
