Mail merge list not recognized

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael HC Design - 08 Feb 2006 20:48 GMT

Document type-Evelope

On the select receiptients tab, using an existing list from an Excel
spreedsheet, prompts to select a table. I pick the set print area table from
the excel spread sheet. Next appears the mail receipients list with the info
from the spreadsheet. I press ok.

Next step to preview envelope-Nothing appears on envelopes besides return
address. The correct number of envelopes are paged but no receipients on any
of the envelopes.

Please help.

Michael

Reply to this Message

Doug Robbins - Word MVP - 08 Feb 2006 21:32 GMT

Did you insert any mergefields into the Address area of the envelope?

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

> Document type-Evelope
>
[quoted text clipped - 13 lines]
>
> Michael

Reply to this Message

Michael HC Design - 08 Feb 2006 21:56 GMT

I have header on the speadsheet that match the Company, Address and City,
State Zip. I have three column on the spreadsheet(1) Company
Name,(2)address(3)City, State, and zip. Does the city state and zip need to
be in seperate columns?

> Did you insert any mergefields into the Address area of the envelope?
>
[quoted text clipped - 15 lines]
> >
> > Michael

Reply to this Message

Peter Jamieson - 08 Feb 2006 22:50 GMT

The problem isn't what is in your spreadsheet, unless you tried to insert an
ADDRESSBLOCK field in the envelope. The problem is that you need to insert
Merge fields into the address area of the envelope. It may be easier to
enable the MailMerge Toolbar (try Tools|Customize, then use the 6th button
from the left ("Insert Merge Fields") to insert the merge fields
corresponding to Company Name, Address, City/State/Zip

Peter Jamieson

>I have header on the speadsheet that match the Company, Address and City,
> State Zip. I have three column on the spreadsheet(1) Company
[quoted text clipped - 23 lines]
>> >
>> > Michael

Reply to this Message

Michael HC Design - 08 Feb 2006 23:01 GMT

Thanks Peter, That was it. I figured it out just before got your reply. I
need to learn how to read. Thanks

> The problem isn't what is in your spreadsheet, unless you tried to insert an
> ADDRESSBLOCK field in the envelope. The problem is that you need to insert
[quoted text clipped - 32 lines]
> >> >
> >> > Michael

Reply to this Message