Mail merge list not recognized

[Michael HC Design]

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

 

[Doug Robbins - Word MVP]

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

--
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

 

[Michael HC Design]

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?

 

[Peter Jamieson]

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

 

[Michael HC Design]

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