Mail merge: update merged document

[jayke]

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

 

[jayke]

One addition: I currently use this code

        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