referencing mergefield (1 Viewer)

[allj]

Hi I want to reference a mergefield in a word document from msaccess03. Something like this except this doesn't work. Thanks any help is much appreciated. Alan

Set objword = GetObject("C:\program files\addedforms\mbhp.doc")

Me!test = objword.{mergefield "enddate"}

 

[DCrake]

Word Merge documents rely on data being provided to it from an external source, such as a database, spreasheet, etc. What you need to do is to identify where the data is sourced and interrogate that. The word document will only "see" the data whilst running the mail merge routine, opening the document as an object will not fire the data grabbing.

David

 

[allj]

Bummer I was hoping to have this truly linked both ways. Alan