Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Why is the city excluded form my mail merge & not the data source?
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Why is the city excluded form my mail merge & not the data source?
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 :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Why is the city excluded form my mail merge & not the data source?
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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 Mail Merge Problem when E-Mailing Data Source | Mailmerge | |||
Mail Merge can't find data source in Office XP...but it could in 2000! | Mailmerge | |||
How do I create a read-only mail merge data source? | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
Mail merge data source problem | Mailmerge |