Mail Merge-State Missing from Address

  • Thread starter Thread starter stripedfrog via OfficeKB.com
  • Start date Start date
S

stripedfrog via OfficeKB.com

Creating a Mail merge for a letter.

When I import the contact information from excel, everything comes in except
for the state. The state is in its own column titled state/province.
 
It sounds like you used the Address Block link to insert the fields and the
field name in your data file does not 'map' to the field name Word is looking
for, so the data from that column is not being included. In order for Word to
include a field, names must match unless you insert the field directly
(rather than clicking "Address Block", for example).

You can go to the 4th step of the Mail Merge Task Pane, click the 'More
Items' link, then click the Match Felds button. Use the State dropdown list
to select State/Province.

Or, you can delete the State field from your form document & use the Step
#4-More Items to insert your State/Province field in it's place. This is the
less desirable choice if you _did_ use the Address Block link.

HTH |:>)
 
You need to "match" your field name with the default Word field name.

On the insert address block window click Match Fields (lower left
corner)
Click the box next to the word State and choose state/province from the
drop down menu
 
Back
Top