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

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" Michael HC wrote in
message ...
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

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?

"Doug Robbins - Word MVP" wrote:

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" Michael HC wrote in
message ...
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

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" wrote in
message news
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?

"Doug Robbins - Word MVP" wrote:

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" Michael HC wrote
in
message ...
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

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

"Peter Jamieson" wrote:

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" wrote in
message news
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?

"Doug Robbins - Word MVP" wrote:

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" Michael HC wrote
in
message ...
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