By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,961 Members | 2,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,961 IT Pros & Developers. It's quick & easy.

Automatically unchecking a box after a mail merge

P: 1
First of all, I want to specify that my office uses Access 2003. I work for a municipality and we log our complaints into Access. Sometimes we need to mail out a letter to the responsible party, so we check the "1st Letter" box. Then run our query. When we open the letter in Word we have over 2000 places to choose from. They go back to at least 2013. Is there any way to have the box "unchecked" automatically after the mail merge is completed? I know I can change the parameters of the query in design view to diminish the number of returns, but I'm trying to keep this as simple as possible since numerous people use it. Thanks for any help you can provide me.
3 Weeks Ago #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,492
If you want to do that then you'll need to drive the mail-merge from code that basically says "Do mail-merge, then reset [1stLetter]".

A mail-merge is basically processing a SELECT-type query which is to read data. Not update it. To have other actions involved you'd need to write VBA code (or possibly even a macro but I don't generally advise using that approach) to manage the whole process.

Does that make sense?
3 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.