Mail Merge - Labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mary - 12 Jul 2004 16:01 GMT

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!

Reply to this Message

Judy - 13 Jul 2004 00:58 GMT

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

> I am attempting to use mail merge to create mailing labels
> (data taken from an Excel spreadsheet). There should be
[quoted text clipped - 6 lines]
>
> Any suggestions on how to remedy this? Many thanks!

Reply to this Message

Graham Mayor - 13 Jul 2004 06:09 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Reply to this Message

Rate this thread: