View Single Post
  #1   Report Post  
Jado
 
Posts: n/a
Default VBA - MailMerge.Fields.Update??

Hi

i'm trying to create a dynamic hyperlink in a MailMerge document.

{HYPERLINK "mailto: ?subject=Email Regarding: {MERGEFIELD
Company}&body=RecordID: {MERGEFIELD Rec_ID}"}

this works, but only if i manually right click over the hyperlink after the
merge has finished and select Update Field from the popup menu.

i've tried adding the following code, but with no success..

......
wdDoc.MailMerge.Execute
wdDoc.Fields.Update
wdDoc.SaveAs......
......

can anyone help?

thanks
Jado