How do I create multiple business cards with mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry - 16 Sep 2005 18:11 GMT

I have an Excel database of 287 names. I want to create 1 page of business
cards for each name using mail merge and a label template. I can put in the
fields but it only prints one card for each name. How do I make it create one
full page for each name?

Reply to this Message

Graham Mayor - 17 Sep 2005 06:19 GMT

Change the merge document type to form letter and remove the next fields
from all the cells, then merge again.

Signature

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

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

> I have an Excel database of 287 names. I want to create 1 page of
> business cards for each name using mail merge and a label template. I
> can put in the fields but it only prints one card for each name. How
> do I make it create one full page for each name?

Reply to this Message

Jerry - 17 Sep 2005 16:35 GMT

I did this but now I have 287 pages which is correct, but only one named
business card on each page; how do I make each cell on page have the
information?

Thanks in advance for your help.

> Change the merge document type to form letter and remove the next fields
> from all the cells, then merge again.
[quoted text clipped - 3 lines]
> > can put in the fields but it only prints one card for each name. How
> > do I make it create one full page for each name?

Reply to this Message

Graham Mayor - 18 Sep 2005 06:50 GMT

Let's try again :(

Start with a label merge and use the propagate function to duplicate the
layout to all the cells (which also adds the Next fields). Then change the
document type to form letter (which will stop Word from trying to
re-introduce the next fields by removing the propagate function). It remains
a table with all the cards completed. Now remove only the Next fields. Merge
to a new document.

Signature

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

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

> I did this but now I have 287 pages which is correct, but only one
> named business card on each page; how do I make each cell on page
[quoted text clipped - 17 lines]
>>> I can put in the fields but it only prints one card for each name.
>>> How do I make it create one full page for each name?

Reply to this Message

Rate this thread: