Mail Merge email addresses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jack - 18 Dec 2003 15:42 GMT

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. John.smith@nowhere.com
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?

Reply to this Message

Cindy M -WordMVP- - 19 Dec 2003 11:19 GMT

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
[quoted text clipped - 3 lines]
>
> 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

:-)

Reply to this Message

Jack - 22 Dec 2003 22:08 GMT

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

>-----Original Message-----
>Hi Jack,
[quoted text clipped - 27 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 23 Dec 2003 10:02 GMT

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

Signature

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

:-)

Reply to this Message