Reply
 
Thread Tools Display Modes
  #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




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 10:21 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"