J
jmcre8
Trying to mail merge for Name Tags. I believe finally solved the issue of how
to perform a mail merge using a SPECIFIC CATEGORY of Contacts in my Outlook
2003 (merged into Word 2003). Here are my steps ... feel free to improve on
this (or clarify language).
MAIL MERGE IN JUST ONE CATEGORY OF OUTLOOK CONTACTS –
To CREATE Name Tags
1) Open Outlook
2) Open Contacts
3) View, Arrange By, Categories
4) Click on + next to category you wish to merge
5) Click on first name in that list, go to bottom of list, hold shift key
and click on last name on list (to select entire group ... use CTRL key to
de-select any you don’t want)
6) Once names are selected, go to Tool, Mail Merge (on Outlook toolbar)
7) A box will appear ... make sure ONLY selected Contacts has bullet point.
8) In the bottom box choose whether it is a form letter, mailing label,
envelopes – then okay
9) Word will now open and “Mail Merge Helper†box will appear
10) In “Mail Merge Helper†click on Setup in Main Document (section 1)
11) Select correct label and press OK
12) In “Mail Merge Helper†click on Edit in Data Source (section 2)
13) Close the gobbly gook document that appears ... this is a temp file will
all the data
14) OK the next box File Conversions – (names same temp file that just
appeared) ... it will be marked ‘Other encoding:’ ‘Unicode’
15) You will now see a layout with your labels with <<Next Record>>
appearing on all but first label
16) In WORD, go to Tools, Letters and Mailing, Mail Merge
17) Skip to Arrange labels and using ‘Database Fields†put in ‘First_Name’
‘Last_Name’
18) Change any formatting now: i.e. center names, change fone sizews, font
color, font size
19) Update all labels
20) Preview your labels
21) Complete merge
22) Edit individual labels (to look for and correct anything that seems odd)
23) SAVE the finished document (if you wish)
NOTE: These same principles apply to doing an envelope mail merge for just
one category.
to perform a mail merge using a SPECIFIC CATEGORY of Contacts in my Outlook
2003 (merged into Word 2003). Here are my steps ... feel free to improve on
this (or clarify language).
MAIL MERGE IN JUST ONE CATEGORY OF OUTLOOK CONTACTS –
To CREATE Name Tags
1) Open Outlook
2) Open Contacts
3) View, Arrange By, Categories
4) Click on + next to category you wish to merge
5) Click on first name in that list, go to bottom of list, hold shift key
and click on last name on list (to select entire group ... use CTRL key to
de-select any you don’t want)
6) Once names are selected, go to Tool, Mail Merge (on Outlook toolbar)
7) A box will appear ... make sure ONLY selected Contacts has bullet point.
8) In the bottom box choose whether it is a form letter, mailing label,
envelopes – then okay
9) Word will now open and “Mail Merge Helper†box will appear
10) In “Mail Merge Helper†click on Setup in Main Document (section 1)
11) Select correct label and press OK
12) In “Mail Merge Helper†click on Edit in Data Source (section 2)
13) Close the gobbly gook document that appears ... this is a temp file will
all the data
14) OK the next box File Conversions – (names same temp file that just
appeared) ... it will be marked ‘Other encoding:’ ‘Unicode’
15) You will now see a layout with your labels with <<Next Record>>
appearing on all but first label
16) In WORD, go to Tools, Letters and Mailing, Mail Merge
17) Skip to Arrange labels and using ‘Database Fields†put in ‘First_Name’
‘Last_Name’
18) Change any formatting now: i.e. center names, change fone sizews, font
color, font size
19) Update all labels
20) Preview your labels
21) Complete merge
22) Edit individual labels (to look for and correct anything that seems odd)
23) SAVE the finished document (if you wish)
NOTE: These same principles apply to doing an envelope mail merge for just
one category.