View Single Post
  #3   Report Post  
tom blower
 
Posts: n/a
Default

Thanks Peter. I wish I could understand the Word object library.
Yes, I am controlling the merge with VBA. I have also found another
way of dealing with this.

Within Access,
objWord.ActiveDocument.Variables.Add.Name:="Varia bleName",

Value:="Whatever"
inserted on the line before
objWord.Run "'ActiveDocument' !Module1.MergeIt"

which starts Word

Within Word
ActiveDocument.SaveAs

FileName:=ActiveDocument.Variables("VariableName") .Value, etc

Since I am already putting the required data into the rtf file and
your neat code is all that is required in each template module, I
will adopt your solution. Many thanks.

Tom