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?

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

--

Graham Mayor - Word MVP

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


Jerry wrote:
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?

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.

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

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


Jerry wrote:
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?

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.

--

Graham Mayor - Word MVP

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




Jerry wrote:
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.

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

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


Jerry wrote:
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?