Can you create multiple labels for mail merge contacts?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Toodlepip - 16 Jan 2006 11:15 GMT

I have a database in excel, from which I would like to merge a sheet of
labels for each contact. Is there any way of printing a sheet of labels per
contact for multiple contacts, as you can for single contacts?

Reply to this Message

Doug Robbins - Word MVP - 16 Jan 2006 12:26 GMT

If you remove the <<Next Record>> field from before each mergefield in the
mail merge main document then you will get a sheet of labels for each record
in the data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a database in excel, from which I would like to merge a sheet of
> labels for each contact. Is there any way of printing a sheet of labels
> per
> contact for multiple contacts, as you can for single contacts?

Reply to this Message

Graham Mayor - 16 Jan 2006 13:39 GMT

I suggest you also change the document type to form letter so that Word will
not contrive to replace the next fields.

Signature

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

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

> If you remove the <<Next Record>> field from before each mergefield
> in the mail merge main document then you will get a sheet of labels
[quoted text clipped - 4 lines]
>> labels per
>> contact for multiple contacts, as you can for single contacts?

Reply to this Message