VBA - Data extraction from rtf file

[tom blower]

Merge uses data from a rtf file. I need to be able to get code to
extract data from one of the fields in the rtf file, which contains
the path and file name to be used when saving the merge result. I do
not want to have to hard-code this which is the easy solution.

Could someone kindly tell me if this is possible and (if so) how to
achieve it?

Access slots the designated path and file name into one of the fields
in the table which is then output as a rtf file followed by code to
start Word and run the merge in the selected template, which is linked
to the rtf file.

Thanks

Tom

 

[Peter Jamieson]

Assuming you are using VBA to execute the merge and save the output, you can
use e.g.

ActiveDocument.MailMerge.DataSource.DataFields("mypathname").Value

to get the value of a field called "mypathname" in the currently loaded
data source record.

Peter Jamieson

 

[tom blower]

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:="VariableName",

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