Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |