Merge with Excel Data Problem

[kathyq]

Whenever I attempt a merge on Word 2002 with an Excel data
source. No data appears on my labels when I complete the
merge. Even though all of the boxes are checked on the
mail merge recipient box. Sometimes I get a repeated
<<Next Record>> indicator but I have been unsuccessful up
to this point. Can you help?
k

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Wilma]

Kathy - You still need to insert the merge fields into your first label on the document. I turn on my merge toolbar. From there you can choose the icon that gives you the field listings (you must have chosen your data source docment, if you haven't you will need to go to this step so it will know what fields are available.) When you are inserting the fields you will notice you have two options. The "Database Fields" will give you what your source file has, the "Address Fields" give you a generic listing that you will have to match to your fields (if the computer doesn't do it correctly for you.) You will need to insert all the fields you want at once, close the insert field window, and then put in the appropriate spacing, puncuation, or move the fields to the correction location in your document. If you are using the merge wizard, then you go to the next step and you will see an option to "Replicate Labels" below this you will see a button for "Update all labels" click on this and it will add the merge fields to the other labels. You can then proceed with your merge.