Hyperlinks with mailmerge

[Erik]

I'm using Access 2000 as the source for my Word mailmerge
document. One of the fields in Access contains a hyperlink
to a website. This hyperlink becomes text in Word.

I'll really appreciate your help.

 

[Cindy M -WordMVP-]

Hi Erik,

I'm using Access 2000 as the source for my Word mailmerge
document. One of the fields in Access contains a hyperlink
to a website. This hyperlink becomes text in Word.

there's really no reliable way to handle this. Word only
accepts text via its link to a mail merge datasource; but no
graphics, charts, hyperlinks, etc.

The one thing you can TRY (but no guarantees) would be
1. Press Ctrl+F9 to insert a pair of field brackets
2. Type: Hyperlink
3. Insert the merge field that will bring across the text
for the hyperlink
4. IMMEDIATELY execute the mail merge *to a new document*
5. In the merge result document:
- Ctrl+A, F9 to force field updates
- Alt+F9 to hide the field codes

If you're very lucky, the hyperlink fields will hyperlink
correctly to the URL that came across for each record during
the merge, and the display text will be that URL.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[Xerxel]

Cind
Your work around is great for creating a new merged document but is there any way to send the working URL in an email

Cheer

Elliott

 

[Doug Robbins - Word MVP]

You need Word XP SP2

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Cindy
Your work around is great for creating a new merged document but is there

any way to send the working URL in an email?