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?

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?

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?