Why do addresses not show up for mail merge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christina - 20 Mar 2007 23:58 GMT

Attempting to merge labels from a excel file into a word mail merge for
labels. First, I don't get addresses for preview. It's a blank page. Also
noticed that the addresses were all out of order like city first, then state,
then name.

Reply to this Message

Doug Robbins - Word MVP - 21 Mar 2007 05:45 GMT

The blank (or almost blank page) is probably because you have not replicated
the set up of the first label on the sheet to the balance of the labels on
the sheet.

The out of order problem is probably caused by your using the AddressBlock
field and the individual merge fields are not matched correctly. Better to
just insert the individual merge fields in the configuration that YOU want
them.

Also see the article "Mailmerge Labels with Word XP" on fellow MVP Graham
Mayor's website at:

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Attempting to merge labels from a excel file into a word mail merge for
> labels. First, I don't get addresses for preview. It's a blank page.
> Also
> noticed that the addresses were all out of order like city first, then
> state,
> then name.

Reply to this Message