 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2006Why 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. Hi =?Utf-8?B?Sm9zZXBo?=, > When I use the mail merge assistant my letter shows an address line such as: > [quoted text clipped - 6 lines] > > 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 :-) Or forget the addressblock field and simply insert the individual fields in the locations you want them.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Cindy M -WordMVP- wrote: > Hi =?Utf-8?B?Sm9zZXBo?=, > [quoted text clipped - 31 lines] > This reply is posted in the Newsgroup; please post any follow > question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.