Mail merge: update merged document

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top