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

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