What's wrong: Only one address block appears per page

[CarolRy]

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?

 

[macropod]

Hi CarolRy,

Which version of Word & Excel?

 

[Gord Dibben]

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/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP