mail merge then update record

F

flister98

How can I create a query that will select records to do a mail merge (with an
Access report) and the update all the clients record indicating a letter was
sent to them? There is a letter table linked to the client table by the
client id. There are several types of letters to be sent. Is it possible to
create a macro to run the SELECT query, do the mail merge with a report, then
run an UPDATE query to add a record in the client's letter table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top