Mail Merge - Labels

[Mary]

I am attempting to use mail merge to create mailing labels
(data taken from an Excel spreadsheet). There should be
214 total labels created. Instead of creating the first 14
labels on page one and then starting page two with label
15, Word 2003 is starting page two with the second
recipients name, page three with the third recipients
label, etc. (So I am ending up with 214 PAGES of labels,
instead of 214 labels.)

Any suggestions on how to remedy this? Many thanks!

 

[Judy]

Hi Mary, I had the same problem....
Once you have asked Word Wizard to create 'labels' and you have chosen the label type you want to use, follow through to next step and insert your merge information (only once though - which will (should) place your merges where the 1st label should be) and then click on 'Propagate Labels' icon and it will insert <<next record>> along with your merges (as in label 1) into the rest of the labels. (you will know if it works, it will display on your screen as I mentioned)

Then follow through with the rest of your merge and it should work!

Judy

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>