If you are still bashing away with the manual solution, have a look at the
post I made in another branch of this conversation - I certainly would not
regard it as either "simple" or "elegant", but it may still save you time if
you are familiar enough with VBA and the VBA editor that you don't have to
struggle too much with VBA stuff.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Don Soucy" wrote in message
...
Graham
I tried that
I put "www.upperroomcom.com/cgi-bin/dwn.pl" etc in the Link field and it
still just merges as text. There seems to be no simple way to merge html.
my (very unelegant) solution is paste the HYPERLINK into the main
document,
merge the Name & EMAIL, generate the merge mailing, then manually edit
the
HYPERLINK code in each letter (ALT F9) before sending them.
Laborious when there are several hundred to do. :-) but what can you do.
Thanks
Don
"Graham Mayor" wrote:
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