Once Mail Merge completed update/insert records in Access table 1

[Andydr]

Hi I'm new to using Access, so this maybe a silly question. I will be running Mail Merge from Access to Word to send letters to multiple recipients based upon the "clients" table in Access. Is it possible that once Word Mail Merge has completed to automatically either update the "clients" table to show that mails have been sent and when, or to insert into another table so I can track what has been sent, to whom and when?

 

[jsolutions]

Andy - this is definitely possible. The best solution would be to add a record to a table that tracks these letters being sent.

First, create a table to track the letters, I'll call it tblLetterTrack. Include the ClientId, Date Sent, Letter ID (if there is one) and any other data you need to track.

If the mail merge is based on the client table (i.e. all clients recieve a mailing), you can simply create an append query based on the client table (create a normal query, go to the query menu and select Append. When prompted, select the table tblLetterTrack.)

You will also want to add fields for the date and Letter code (probably parameters). Then anytime that you run the query, the table tblLetterTrack will be appended with this data.

If you want to automate this process, in the code that launches the mail merge, add some code to run the query (See docmd.execute in Access Help).

I know you are new to Access - so if this did nothing but bring up other questions, just let me know.

Jay

 

[Andydr]

Thanks Jay,
Found another way round the problem. Created input forms that write the selected data back to the tables and usede Macro's to invoke Mail Merge to Word. May not be the most elegant way but works OK.