Problem with mail merge output - please help

[James Houston]

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 Kenyon]

Is your text Justified?
--

Charles 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

 

[James Houston]

Charles
That was it. Thanks. I never thought to check that. Does Word
automatically justify merged text?

Thanks again

Jim

 

[Cindy M -WordMVP-]

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