Merging email address from access to word

[Michael C C G]

Hi,

I want to merge email addresses from access to a word document. I want to
display the email address in the merge field in Word. The problem is that a
hyperlink is added to the address and displayed. e.g. instead of
[email protected] being displayed I get
[email protected]#http://[email protected]# displayed.
I would greatly appreciate help with this problem.

Thanks.

 

[Arvin Meyer [MVP]]

Append:

mailto:

to the beginning of every record. You may also have to add a hash (#) to the
beginning and end of each record. The update query might look something
like:

UPDATE MyTable SET MyEmail = "#MailTo:" & [MyEmail] & "#";