How do I create multiple business cards with mail merge?

[Jerry]

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?

 

[Graham Mayor]

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

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


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

 

[Jerry]

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]

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


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