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