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.
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
|