mailto merge switch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AN - 09 Dec 2005 16:07 GMT

I am merging a directory of email addresses from Access into Word. The
Access field is a hyperlink to email the contacts. When I merge to a new
document, I get the email addresses and #mailto:emailaddress# at the end of
the address. Are there any switches so that only the email addresses shows
and not the #mailto:emailaddress# information? Currently I have a macro that
eliminates that information but it would be nice to skip that step. Any
ideas would be greatly appreciated.

Signature

AN
Behold, children are a heritage from the Lord.

Reply to this Message

Doug Robbins - Word MVP - 09 Dec 2005 19:25 GMT

Change the field type in the database to a textfield.

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

>I am merging a directory of email addresses from Access into Word. The
> Access field is a hyperlink to email the contacts. When I merge to a new
[quoted text clipped - 6 lines]
> eliminates that information but it would be nice to skip that step. Any
> ideas would be greatly appreciated.

Reply to this Message

AN - 09 Dec 2005 19:41 GMT

Thanks for you input, but changing the field to a text field does away with
the reason why it is a hyperlink. I regularly click on their email address
in Access to email individuals but I also like to email groups of people. I
use word to merge them. Maybe Word is not able to do what I ask. I will try
another avenue.

Signature

AN
Behold, children are a heritage from the Lord.

> Change the field type in the database to a textfield.
>
[quoted text clipped - 8 lines]
> > eliminates that information but it would be nice to skip that step. Any
> > ideas would be greatly appreciated.

Reply to this Message

Doug Robbins - Word MVP - 09 Dec 2005 21:53 GMT

You should be able to do the same thing with an Access report.
Alternatively, the use of the Format() function in a query may covert the
hyperlink to text so that when you merge you just get what you want.

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

> Thanks for you input, but changing the field to a text field does away
> with
[quoted text clipped - 22 lines]
>> > Any
>> > ideas would be greatly appreciated.

Reply to this Message