[Joseph]

When I use the mail merge assistant my letter shows an address line such as:

Joseph Schrader
400 Court St.
, MI 48602

When the city "Saginaw" should be in front of the comma. When I pick my
data source it has a city included in the field.

I am using an excel spreadsheet as the data source.

[Cindy M -WordMVP-]

Hi ?B?Sm9zZXBo?=,

When I use the mail merge assistant my letter shows an address line such as:

Joseph Schrader
400 Court St.
, MI 48602

When the city "Saginaw" should be in front of the comma. When I pick my
data source it has a city included in the field.

I am using an excel spreadsheet as the data source.

Let's start with which version of Word you're using?

And what command(s) are you using to insert the address information?

Based on the little you give us, I'm guessing that you're inserting an
AddressBlock and that Word isn't recognizing that the field (column) coming
in from the Excel document should be mapped to its internal "City" field.

In the "Address Block" dialog box you should see a "Match fields" button.
Click that. Look for "City" in the list. Choose the appropriate Excel field
name from the dropdown list at the right, in the same line.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

[Graham Mayor]

Or forget the addressblock field and simply insert the individual fields in
the locations you want them.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Cindy M -WordMVP- wrote:
Hi ?B?Sm9zZXBo?=,

When I use the mail merge assistant my letter shows an address line
such as:

Joseph Schrader
400 Court St.
, MI 48602

When the city "Saginaw" should be in front of the comma. When I
pick my data source it has a city included in the field.

I am using an excel spreadsheet as the data source.

Let's start with which version of Word you're using?

And what command(s) are you using to insert the address information?

Based on the little you give us, I'm guessing that you're inserting an
AddressBlock and that Word isn't recognizing that the field (column)
coming in from the Excel document should be mapped to its internal
"City" field.

In the "Address Block" dialog box you should see a "Match fields"
button. Click that. Look for "City" in the list. Choose the
appropriate Excel field name from the dropdown list at the right, in
the same line.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)