View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default How to create an email from mail merge including a hyperlink, so that the value of a merged field is included as part of the hyperlink URL, not just part of its text.


Yes, there should be a colon after address, i.e.

Set h = Doc.Hyperlinks.Add(Anchor:= r, Address:= lt, TextToDisplay:=dt)

--
Peter Jamieson
http://tips.pjmsn.me.uk

wrote in message
oups.com...
On 20 Aug, 13:47, wrote:
Peter - I'll try this out and confirm this week, thanks very much for
this, it's greatly appreciated !!!

Nick


Peter thanks - almost worked but we get a syntax error at;

' insert the hyperlink you want
Set h = Doc.Hyperlinks.Add(Anchor:= r, Address = lt, TextToDisplay:=
dt)

any ideas?

Nick