473,324 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Automatically unchecking a box after a mail merge

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.
Sep 24 '19 #1
1 856
NeoPa
32,556 Expert Mod 16PB
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?
Sep 25 '19 #2

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

Similar topics

0
by: joanie | last post by:
I'm attempting to create a mail merge between Word and an Oracle Form. The form letter will exist in Word, but the data source will be a sql query from the database. The user will interact with a...
2
by: Aaron | last post by:
hello, i am perfoming a mail merge with the following code. Public Function MergeIt() Dim objWord As Object Set objWord = GetObject("C:\MyMerge.doc", "Word.Document") ' Make Word visible....
1
by: Lisa | last post by:
I have a query named QryDept where one of the fields is DeptID. The query is used for the data source of a mail merge letter. I would like to control which department is to get the mail merge...
8
by: Squirrel | last post by:
Hi everyone, I've created a mail merge Word doc. (using Office XP) , the data source is an Access query. Functionality I'm attempting to set up is: User sets a boolean field to true for...
3
by: Andy Davis | last post by:
I have set up a mail merge document in Word 2003 which gets its data from my Access 2000 database. I want to set up a button on a form that: 1. runs the query to provide the dat for the merge...
5
by: Simon | last post by:
on my database i have a customers Table (tblCustomers) on the form of it (frmCustomers) i would like a button what will open up word and open up my comapny letter head template and then merger...
2
by: Viperoptic | last post by:
Hi There I am new at this and trying to work my way around this. I have a table with customer names and a comments and a e-mail address, Purpose: I need to send a e-mail to all these users...
6
by: crealesmith | last post by:
Firstly, I have no problem with mail merging to Word, VB code for that works perfectly. On one mail merge I need to merge 15 fields of data that are from 3 seperate records. The 3 records are all...
2
by: Bill Millerd | last post by:
I am performing a mail merge and generating e-mails automatically from an Access Table. When I click the "Merge to Email" icon in Word, the resulting dialog box only allows me to select one field...
1
by: TommyGunn | last post by:
Hi everyone, Is there anyway to automatically put Access data into Mail Merge in an existing Word doc with content? I have bits and pieces of this done, but I can't seem to put it all together....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.