Mail Merge Issues!

[Cheyenne]

Need Help!

Trying to create labels from Excel spreadsheet even
Outlook.
Following all rules and yet in the end document contains
msg "<<New Record>>" and not the name, address, ph. etc.
What am I doing wrong!!!!!?????
My steps are as follows:
Tools < Letters and Mailings < Mail Merge Wizard
1. Select Document Type: Labels
2. Label Options
3. Select Recipients: Browse (selected)
And this is where everything goes wrong ... the
information contained on my labels document is:
<<New Record>> and nothing else!!!
Please help.

Thanks

 

[Peter Jamieson]

Whenyou create the label merge, no Mailmerge data fields are inserted by
default, not even address fields. The only thing inserted by default is a
<<Next record>> feild for each label (except the first) which means that the
data for each new label will come from a new record.

So you have to add the fields you want. Precisely how you do this depends on
what information you want for each label and which version of Word you are
using, but
a. if you are using Word 2002 or later you could try inserting an
ADDRESSBLOCK field
b. in any version of word, you can add individual fields such as street
address, city, state, etc. or whatever is available in your data source.
c. in either case, you need to test the results (e.g. using print preview)
before merging and printing
d. In Word 2003, there's a "propagate" option which allows you to copy the
content of cell 1 to all the other cells, and which maintains "Next Record"
correctly. In older versions of Word, you can create an entry consisting of
<<Next Record>> followed by whatever fields you want. Then copy it to al the
cells in the table. The remove the <<Next record>> field from the first
cell.