Mail Merge hyperlinks - Without ##

[Ian McKeag]

I am mail merging in word, URL's from a hyperlink field in an Access
database. However when they are merged, it is duplicated and includes hash’s
##

e.g. www.url.com#www.url.com# or (e-mail address removed)#[email protected]#

From what I understand, the hyperlink field in access is made up of 'text to
display#URL#subaddress'. So..

Is there any way to only show the 'text to display' or 'URL' part of the
hyperlink, without the #'s and without repeating?

Any help would be great!
Muchos gracias,
Ian McKeag

 

[Peter Jamieson]

Reply posted to your later version/duplicate of this question.

Peter Jamieson

http://tips.pjmsn.me.uk