Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I merge more than one page of my Excel spreadsheet?
Hi,
When I do a mail merge with Excel, I only get one page of labels in Word even though all rows are checked and matched from Excel. My Avery sheet has 30 labels per page and that's all I get - one page of merged lables. I expected to be able to get all the addresses on multiple Word pages. What am I not doing? -- Jennifer P |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I merge more than one page of my Excel spreadsheet?
It sounds as if you are previeing the merge and/or perhaps using File|Print
to print the results. But what you need to do is "complete" the merge, either by /merging to the printer/, which is different from using File|Print, or /merging to an output document/ then printing it. If you are using the Mailmerge wizard in Word 2002/2003, make sure you go to the very last step in the task pane, and click one of the options there - the wording is ambiguous. Or enable the Mailmerge toolbar (Word Tools|Customize|Toolbars) and use the appropriate button near the right-hand end. Peter Jamieson "Jennifer P" wrote in message ... Hi, When I do a mail merge with Excel, I only get one page of labels in Word even though all rows are checked and matched from Excel. My Avery sheet has 30 labels per page and that's all I get - one page of merged lables. I expected to be able to get all the addresses on multiple Word pages. What am I not doing? -- Jennifer P |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I merge more than one page of my Excel spreadsheet?
The procedure is illustrated at
http://www.gmayor.com/mail_merge_lab...#only_one_page -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Peter Jamieson wrote: It sounds as if you are previeing the merge and/or perhaps using File|Print to print the results. But what you need to do is "complete" the merge, either by /merging to the printer/, which is different from using File|Print, or /merging to an output document/ then printing it. If you are using the Mailmerge wizard in Word 2002/2003, make sure you go to the very last step in the task pane, and click one of the options there - the wording is ambiguous. Or enable the Mailmerge toolbar (Word Tools|Customize|Toolbars) and use the appropriate button near the right-hand end. Peter Jamieson "Jennifer P" wrote in message ... Hi, When I do a mail merge with Excel, I only get one page of labels in Word even though all rows are checked and matched from Excel. My Avery sheet has 30 labels per page and that's all I get - one page of merged lables. I expected to be able to get all the addresses on multiple Word pages. What am I not doing? -- Jennifer P |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ending page numbering | Microsoft Word Help | |||
I want to start Page '1' on the 3rd page. HOW???????? HELP????? | Page Layout | |||
Want to start page 1 numbering after five pages - how? | Page Layout | |||
word 2003 hangs during merge to excel spreadsheet | Mailmerge | |||
page number printing on a merged report | Mailmerge |