Mail Merge email addresses

[Jack]

I'm trying to merge a comma dilimited file and everything
works great, except the email address. It drops the
symbols out of the address. EX. (e-mail address removed)
displays as Johnsmithnowherecom. I've tried putting the
address in quotes, but it doesn't change.

Obviously I can't mail with this address.

Any Ideas?

 

[Cindy M -WordMVP-]

Hi Jack,

Version of Word?

Do you know which connection method Word is using to link to
the data file?

If you first open the text file in Word, do you see symbols?
If yes, save it as a Word document. does it work now as a
data source?

I'm trying to merge a comma dilimited file and everything
works great, except the email address. It drops the
symbols out of the address. EX. (e-mail address removed)
displays as Johnsmithnowherecom. I've tried putting the
address in quotes, but it doesn't change.

Obviously I can't mail with this address.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Jack]

I'm using Ofiice 2003.

Everthing looks great until I match fields, then the
symbols are removed. I've tried a text, word, and excel
and they all do the same, so it leads me to believe it
has something to do with the merge function in Word.

Jack

 

[Cindy M -WordMVP-]

Hi Jack,

I'm using Ofiice 2003.

Everthing looks great until I match fields, then the
symbols are removed. I've tried a text, word, and excel
and they all do the same, so it leads me to believe it
has something to do with the merge function in Word.

Ah, matching fields. OK... I rarely use that since I don't
really like the Address and Greeting blocks.

What changes are you making, here? If I try "any old thing"
the ampersand (@) in the Email Address is still retained.
Could you give me the names of a few of the fields your
data source file contains so that I can try to duplicate?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail