Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jerry
 
Posts: n/a
Default How do I create multiple business cards with mail merge?

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?
  #2   Report Post  
Graham Mayor
 
Posts: n/a
Default

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?



  #3   Report Post  
Jerry
 
Posts: n/a
Default

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?




  #4   Report Post  
Graham Mayor
 
Posts: n/a
Default

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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create multiple pages of mail merge listings Kathy Mailmerge 2 July 27th 05 10:11 PM
how do you mail merege into business cards? VJ Mailmerge 1 July 13th 05 09:13 PM
How to create my own business cards upthearts Mailmerge 1 May 19th 05 07:47 AM
I'm looking to create some simple business cards. violabratsche Microsoft Word Help 1 April 2nd 05 03:13 PM
how do you create and print business cards Chucker Microsoft Word Help 2 March 30th 05 04:23 AM


All times are GMT +1. The time now is 11:41 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"