| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What's wrong: Only one address block appears per page
I repeatedly have followed the steps in Office Help to create a mail merge
from Excel to Word. When I click Preview Results, only one name shows up in the upper left corner per page. How do I get the 30 address blocks per page, which is how my labels are arranged? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What's wrong: Only one address block appears per page
Hi CarolRy,
Which version of Word & Excel? -- Cheers macropod [Microsoft MVP - Word] "CarolRy" wrote in message ... I repeatedly have followed the steps in Office Help to create a mail merge from Excel to Word. When I click Preview Results, only one name shows up in the upper left corner per page. How do I get the 30 address blocks per page, which is how my labels are arranged? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What's wrong: Only one address block appears per page
Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm Gord Dibben MS Excel MVP On Mon, 27 Jul 2009 13:39:01 -0700, CarolRy wrote: I repeatedly have followed the steps in Office Help to create a mail merge from Excel to Word. When I click Preview Results, only one name shows up in the upper left corner per page. How do I get the 30 address blocks per page, which is how my labels are arranged? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert address block into delimited rows? | Excel Discussion (Misc queries) | |||
| e mail address appears & prints blue instead of black | Excel Discussion (Misc queries) | |||
| Sorting a block of page number citations | Excel Worksheet Functions | |||
| Address block carriage returns not correct | Excel Worksheet Functions | |||
| Mail Merge creates a space in the address block | Excel Discussion (Misc queries) | |||
Linear Mode
