I've worked this one outusing SendKeys, but if there's a more robust way,
please let me know
wdDoc.MailMerge.Execute
SendKeys "^a" ' Ctrl+a, Selects all fields in the document
SendKeys "{F9}" 'F9 FunctionKey, Updates all fields in
document
remove the
wdDoc.Fields.Update
as this has no effect.
"Jado" wrote in message
...
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