 |
 | 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 / April 2004Problem with mail merge output - please help
I'm having a strange problem with the output of a mail merge. Here's the situation. I'm using Word 97 to merge with a list of addresses in an Access 97 database. The data source is a select query that draws its data from two tables. My document has the following format: «CUSTNAME» «ADDRESS1» «ADDRESS2» «CITY»«STATE»«ZIP» The problem shows up when I select Merge to New Document. If there are any spaces between the City, State and Zip fields, the output, which should look like this: Drake, CO 80515 looks like this: Drake, CO 80515 The same problem shows up if there is a space within the City field, thus Las Vegas comes out looking like this: Las Vegas Anyone have any idea why this is happening? My OS is Windows XP Home, service pack 1. Thanks in advance. Jim Is your text Justified?  SignatureCharles Kenyon Word New User FAQ & Web Directory: <URL: http://addbalance.com/word/index.htm> Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) <URL: http://addbalance.com/usersguide/index.htm> See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. I'm having a strange problem with the output of a mail merge. Here's the situation. I'm using Word 97 to merge with a list of addresses in an Access 97 database. The data source is a select query that draws its data from two tables. My document has the following format: ?CUSTNAME? ?ADDRESS1? ?ADDRESS2? ?CITY??STATE??ZIP? The problem shows up when I select Merge to New Document. If there are any spaces between the City, State and Zip fields, the output, which should look like this: Drake, CO 80515 looks like this: Drake, CO 80515 The same problem shows up if there is a space within the City field, thus Las Vegas comes out looking like this: Las Vegas Anyone have any idea why this is happening? My OS is Windows XP Home, service pack 1. Thanks in advance. Jim Charles That was it. Thanks. I never thought to check that. Does Word automatically justify merged text? Thanks again Jim > Is your text Justified? > I'm having a strange problem with the output of a mail merge. Here's the [quoted text clipped - 25 lines] > > Jim Hi James, > That was it. Thanks. I never thought to check that. Does Word > automatically justify merged text? Seems Charles hasn't seen this :-) No, by default merged text isn't justified, or anything else (except no proofing). It should reflect the formatting of the paragraph into which it's been inserted. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) 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 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.