[Trojans86]

I am trying to do a mail merge with envelopers, merging data from excel.
I add the recipient information in the address location by only choosing
"Address" once, however, it is only retrieving the Name, street address, City
and zip of the client. It is not, however, picking up the State which is in
the column located n the excel sheet between the city and zip. Any help?
Please? Thanks

[Doug Robbins - Word MVP]

I assume that by Address you mean that you are using the Address Block
field. Instead of doing that, just insert the individual merge fields that
you want to use in the configuration that you want them.

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

"Trojans86" wrote in message
...
I am trying to do a mail merge with envelopers, merging data from excel.
I add the recipient information in the address location by only choosing
"Address" once, however, it is only retrieving the Name, street address,
City
and zip of the client. It is not, however, picking up the State which is
in
the column located n the excel sheet between the city and zip. Any help?
Please? Thanks

[Trojans86]

Yes, This did it!!! Thanks.

"Doug Robbins - Word MVP" wrote:

I assume that by Address you mean that you are using the Address Block
field. Instead of doing that, just insert the individual merge fields that
you want to use in the configuration that you want them.

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

"Trojans86" wrote in message
...
I am trying to do a mail merge with envelopers, merging data from excel.
I add the recipient information in the address location by only choosing
"Address" once, however, it is only retrieving the Name, street address,
City
and zip of the client. It is not, however, picking up the State which is
in
the column located n the excel sheet between the city and zip. Any help?
Please? Thanks