e-mail addresses for Word mail merge have format error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cjfi - 05 Jun 2006 13:51 GMT

Using Word Mail Merge for e-mails with data file from Excel. e-mail
addresses are coming through into merge with "#" in place of "." Obviously,
they won't work.

Help!

Reply to this Message

Doug Robbins - Word MVP - 05 Jun 2006 16:54 GMT

Try attaching the Excel File to the mailmerge main document using the DDE
method. From the Tools menu, select Options and then on the General tab,
check the box against the "Confirm conversions at open" item. Then when you
re-attach the data source, you will be presented with a dialog that allows
you to select the method of connection.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Using Word Mail Merge for e-mails with data file from Excel. e-mail
> addresses are coming through into merge with "#" in place of "."
> Obviously,
> they won't work.
>
> Help!

Reply to this Message

Rate this thread: