Mail Merge: Clickable Hyperlink

[Sandi]

I would like clickable hyperlink on mail merge to actually work. In my access 2003 database the field that corresponds to the Hyperlink is named “VideoLink1” and I have made it a Hyperlink type field. However, when I insert the field within a MS word Hyperlink field brackets shown like this:



{ HYPERLINK { MERGEFIELD "VideoLink1" } }

Then merge new document, I am able to see its shown as a hyperlink ie. blue font BUT when the pointer hovers over it, the javascript note as it should says CTRL + Click to follow link and I do that, ctrl and click but the link does not open. Just to make it clear the my links are correct.

Can someone tell me how to get it to work please?

[June7]

Google: word access mail merge hyperlink

Maybe this will help. It is Word/Outlook but the issue seems same: http://support.microsoft.com/kb/912679

or this from another thread:
"In your newly merged document, click on Edit...Select All..., then press F9.
This should update your fields and make them active links.
If you want the links to be blue in the final merge doc, go back to the
original, press Alt + F9 to view the code, in your hyperlink field delete
the part that says */ mergeformat, then merge. Update as above.In your newly merged document, click on Edit...Select All..., then press F9.
This should update your fields and make them active links.
If you want the links to be blue in the final merge doc, go back to the
original, press Alt + F9 to view the code, in your hyperlink field delete
the part that says */ mergeformat, then merge. Update as above."

[Sandi]

I followed the thread you advised, quote:

"In your newly merged document, click on Edit...Select All..., then press F9.
This should update your fields and make them active links.
If you want the links to be blue in the final merge doc, go back to the
original, press Alt + F9 to view the code, in your hyperlink field delete
the part that says */ mergeformat, then merge. Update as above.In your newly merged document, click on Edit...Select All..., then press F9.
This should update your fields and make them active links.
If you want the links to be blue in the final merge doc, go back to the
original, press Alt + F9 to view the code, in your hyperlink field delete
the part that says */ mergeformat, then merge. Update as above."

I got it to look like a Hyperlink ie. blue font BUT my big question is how can I get the hyperlink to work, when CTRL + click, the link does not open, I think the problem is to do with the hash keys on either side of the link (Right click; Edit Hyperlink). So when I remove the hash keys its working but I don't want to be doing that for each and every link, so is there a way to automatically remove the hash keys to get the links to work??????? or is there another way?

[June7]

I have never done document merging. That was the best info I could find. Maybe VBA code behind the Word document could do search/replace on the hyperlinks. This is all beyond my experience. You might have luck with a google search on: Word VBA edit hyperlink