Hyperlink merge field

[Annette]

I am trying to send out a personalized email via a Word
2002 mail merge. My Excel 2002 spreadsheet has three
columns-- Name, Email and Web_Address. I would like to
add the hyperlinked web_address merge field to the body of
the email message, but no matter what I do, the link
isn't "hot". Could someone please explain how I activate
a hyperlink on a merged field with the URL contained in
the Excel spreadsheet?

P.S. I've found a couple of KB articles about Hyperlinks
in mail merge, but they say the problem was resolved with
SP2 and I have SP3.

Thanks in advance!

 

[Cindy M -WordMVP-]

Hi Annette,

I am trying to send out a personalized email via a Word
2002 mail merge. My Excel 2002 spreadsheet has three
columns-- Name, Email and Web_Address. I would like to
add the hyperlinked web_address merge field to the body of
the email message, but no matter what I do, the link
isn't "hot". Could someone please explain how I activate
a hyperlink on a merged field with the URL contained in
the Excel spreadsheet?

Are you inserting the hyperlink information into a Hyperlink
field in Word?

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