Mail Merge only merges 2 records

[Katie Drake]

I'm trying to create mailing labels by merging records
from an Excel file to Word 2002. Using the mail merge
wizard, it shows that all of my records are selected, but
when I perform the merge, only two come into the label
document - one at the top of page 1, one at the top of
page 2, and that's it.

Any ideas would be most welcome! Thanks~
Katie

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Katie,

Did you Propogate the data to each label on the sheet. It's best to turn on
the Mail merge toolbar by clicking that option under View>Toolbars. There's
a button on that toolbar for that purpose (and everything else that you want
to do with mail merge) so you can dispense with the dumb Wizard.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Peter Jamieson]

How many records do you have?

How many labels per page should you have?

Does your mail merge main document contain one or two pages (typically it
should be one).

Are you definitely performing the merge as opposed to previewing the data?

Did you use the "propagate labels" button to make a copy of the contents of
the first cell in the table in the mail merge main document? (i.e., are
there suitable merge fields in every cell of the table?