As you have found, Hyperlinks when merged merely produce the display text
from the data source. I cannot think of any easy way of merging the
hyperlink. You could simply insert the URL without the hyperlink text into
your data source and that should work but see
http://support.microsoft.com/kb/287004 which is a fairly old link but may
point a way forward.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Don Soucy wrote:
Graham
This is the html link as it appears in third column of EXCEL
Download Bio-Energetic Relaxation.mp3
except in EXCEL it is a HYPERLINK (Blue underlined and when moused
over shows
a
href="http://www.upperroomcomm.com/cgi-bin/dwn.pl?ID=MP3-relax64k.mp3&TXN=COMPLIMENTARY2009-0001"
title="http://www.upperroomcomm.com/cgi-bin/dwn.pl?ID=MP3-relax64k.mp3&TXN=COMPLIMENTARY2009-0001"Download
Bio-Energetic Relaxation.mp3/a
Does this make it clearer?
Don
"Graham Mayor" wrote:
What *exactly* does the third column contain.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Don Soucy wrote:
I want to use a data file consisting of 3 columns, a name, an e-mail
address and a unique html link and merge it into an e-mail message.
When I try, the html link loses the underlying format and appears as
plain text.
I've tried saving the data file from Excel in a variety of formats
with no success.
I've treid formatting the {{LINK}} placeholder as HTML and still no
luck
Any suggestions?
Thanks