Mail merge: update merged document

[Guest]

Hi,

I am currently working on an application which merges addresses from an
acces addressbook to a Word template. So far I succeeded.
BUT, the customer would like to have a preview document (concept), which can
be reviewed and edited by other people and eventually be made final! So all
merge fields need te be updated with the latest database data and the
reviewed/updated text needs to remain in the document.

I foud out that I cannot update an already merged document or I think it
cannot be done. Is there a way to do this?

Thanks,

Jayke

 

[Guest]

An addition: I currenly use this code to make the connection

Set objWord = GetObject(s_templateDocNaam, "Word.Document")
' Make Word visible.
objWord.Application.Visible = True

strConnect = "DSN=MS Access Database;DBQ=" & CurrentDb.Name &
"FIL=MS Access;"

objWord.MailMerge.OpenDataSource _
Name:=CurrentDb.Name, _
LinkToSource:=True, _
Connection:="QUERY qryMaakBrief", _
SQLStatement:="SELECT * FROM [qryMaakBrief]"

' this part in case of printing
objWord.MailMerge.Destination = wdSendToNewDocument

' Execute the mail merge.
objWord.MailMerge.Execute