I have a database in Access where the user wants to do an envelope mail merge in Word. I’ve figured out enough to make the Word document to include envelopes and to initially pull data from a query I have in the database, and created an ODC file for the data access (if I understood it correctly). In testing it I found that if I change the values in the database those changes aren’t reflected in the Word document. My goal is to provide the end user with an already merged Word document with the data dynamically updated from the query I created in the database. I will also need to know how to alter the data source so I can tell the user how to point it to the database in whatever directory they decided to put it in on their hard drive.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Mail Merge with MS Access data source (Word/Access 2K)
Home » Forums » AskWoody support » Productivity software by function » MS Word and word processing help » Mail Merge with MS Access data source (Word/Access 2K)
- This topic has 7 replies, 3 voices, and was last updated 20 years, 8 months ago.
AuthorTopicWSMike Shea
AskWoody LoungerSeptember 7, 2004 at 5:37 pm #409607Viewing 2 reply threadsAuthorReplies-
WSjscher2000
AskWoody LoungerSeptember 7, 2004 at 6:59 pm #874320“Already merged” and “dynamically updated” seem to be two things that do not mix.
As an alternative, and depending on the nature of the data, you could give the user a button to query the database and update data elements stored as document variables. To display those data elements into the document, you would pre-position DOCVARIABLE fields, populated with default or start values. Then at the end of the macro that updates those values you would refresh the fields in the document to display the changed variables.
-
WSPhil Rabichow
AskWoody LoungerSeptember 8, 2004 at 12:39 am #874432Mail merge will not allow you to update the merged document without doing the merge over. So one alternative is to do a merge every time the datasource changes.
Another is to use Insert/Database button from the Database toolbar. This will automatically update when the source file changes. However, if you want a particular format, it’s probably easier to do a query in Access & then link to the query.
-
WSMike Shea
AskWoody LoungerSeptember 8, 2004 at 4:17 pm #874745Phil, If I understand you correctly, a link to a query is exactly what I’m looking for. But when you open the Word document, it would need to update itself using the query in the MS Access database. It would also be helpful if there was a button in Word to refresh this dataset and update the merge Word document (maybe this is what you already described). Is it possible to create the merge in Word, tie it to a query in an Access database, and give it to the end user with instruction on how to change the Word merged datasource to point to the directory they put the Access DB in?
-
WSPhil Rabichow
AskWoody LoungerSeptember 9, 2004 at 5:09 am #875021Hi Mike:
Sorry for the delay, but I’ve been offline all day. If you insert the database, this is a field that will update. However, it will look like a table from Access. Yes, you can use queries. If you show the Database toolbar in Word, you’ll see a button for inserting a database. Browse for it &, if there are queries in the database, you will get a dialog box letting you select which query you want. You will have a choice between DDE & ODBC. I would try using DDE.Once you insert the database, there is another button on the Database toolbar to update the field. Also, if you go to Insert/Field…/Database/Options, you will see a number of switches that you can use to choose which records to use & numerous other options.
However, the structure of the end document is not as flexible as when doing a mail merge. There, you can place merge fields anywhere in the document. If I knew what type of structure you wanted your end document to have, I might be able to be more specific.
P.S. Just for clarity, when talking about a mail merge, Word uses 3 terms: the datasource (your database), the main document (contains the structure & instructions for the merge), & the merged document (the result).
Hope this helps, -
WSPhil Rabichow
AskWoody LoungerSeptember 9, 2004 at 5:09 am #875022Hi Mike:
Sorry for the delay, but I’ve been offline all day. If you insert the database, this is a field that will update. However, it will look like a table from Access. Yes, you can use queries. If you show the Database toolbar in Word, you’ll see a button for inserting a database. Browse for it &, if there are queries in the database, you will get a dialog box letting you select which query you want. You will have a choice between DDE & ODBC. I would try using DDE.Once you insert the database, there is another button on the Database toolbar to update the field. Also, if you go to Insert/Field…/Database/Options, you will see a number of switches that you can use to choose which records to use & numerous other options.
However, the structure of the end document is not as flexible as when doing a mail merge. There, you can place merge fields anywhere in the document. If I knew what type of structure you wanted your end document to have, I might be able to be more specific.
P.S. Just for clarity, when talking about a mail merge, Word uses 3 terms: the datasource (your database), the main document (contains the structure & instructions for the merge), & the merged document (the result).
Hope this helps,
-
-
WSMike Shea
AskWoody LoungerSeptember 8, 2004 at 4:17 pm #874746Phil, If I understand you correctly, a link to a query is exactly what I’m looking for. But when you open the Word document, it would need to update itself using the query in the MS Access database. It would also be helpful if there was a button in Word to refresh this dataset and update the merge Word document (maybe this is what you already described). Is it possible to create the merge in Word, tie it to a query in an Access database, and give it to the end user with instruction on how to change the Word merged datasource to point to the directory they put the Access DB in?
-
-
WSPhil Rabichow
AskWoody LoungerSeptember 8, 2004 at 12:39 am #874433Mail merge will not allow you to update the merged document without doing the merge over. So one alternative is to do a merge every time the datasource changes.
Another is to use Insert/Database button from the Database toolbar. This will automatically update when the source file changes. However, if you want a particular format, it’s probably easier to do a query in Access & then link to the query.
Viewing 2 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Pwn2Own Berlin 2025: Day One Results
by
Alex5723
2 minutes ago -
Windows 10 might repeatedly display the BitLocker recovery screen at startup
by
Susan Bradley
55 minutes ago -
Windows 11 Insider Preview Build 22631.5409 (23H2) released to Release Preview
by
joep517
2 hours, 11 minutes ago -
Windows 10 Build 19045.5912 (22H2) to Release Preview Channel
by
joep517
2 hours, 13 minutes ago -
Kevin Beaumont on Microsoft Recall
by
Susan Bradley
9 hours, 14 minutes ago -
The Surface Laptop Studio 2 is no longer being manufactured
by
Alex5723
10 hours, 20 minutes ago -
0Patch, where to begin
by
cassel23
4 hours, 22 minutes ago -
CFPB Quietly Kills Rule to Shield Americans From Data Brokers
by
Alex5723
23 hours, 58 minutes ago -
89 million Steam account details just got leaked,
by
Alex5723
11 hours, 44 minutes ago -
KB5058405: Linux – Windows dual boot SBAT bug, resolved with May 2025 update
by
Alex5723
1 day, 8 hours ago -
A Validation (were one needed) of Prudent Patching
by
Nibbled To Death By Ducks
23 hours, 30 minutes ago -
Master Patch Listing for May 13, 2025
by
Susan Bradley
10 hours, 37 minutes ago -
Installer program can’t read my registry
by
Peobody
5 hours, 35 minutes ago -
How to keep Outlook (new) in off position for Windows 11
by
EspressoWillie
21 hours, 17 minutes ago -
Intel : CVE-2024-45332, CVE-2024-43420, CVE-2025-20623
by
Alex5723
1 day, 4 hours ago -
False error message from eMClient
by
WSSebastian42
1 day, 19 hours ago -
Awoke to a rebooted Mac (crashed?)
by
rebop2020
2 days, 4 hours ago -
Office 2021 Perpetual for Mac
by
rebop2020
2 days, 5 hours ago -
AutoSave is for Microsoft, not for you
by
Will Fastie
1 day, 2 hours ago -
Difface : Reconstruction of 3D Human Facial Images from DNA Sequence
by
Alex5723
2 days, 9 hours ago -
Seven things we learned from WhatsApp vs. NSO Group spyware lawsuit
by
Alex5723
1 day, 10 hours ago -
Outdated Laptop
by
jdamkeene
2 days, 14 hours ago -
Updating Keepass2Android
by
CBFPD-Chief115
2 days, 20 hours ago -
Another big Microsoft layoff
by
Charlie
2 days, 19 hours ago -
PowerShell to detect NPU – Testers Needed
by
RetiredGeek
17 hours, 21 minutes ago -
May 2025 updates are out
by
Susan Bradley
1 hour, 13 minutes ago -
Windows 11 Insider Preview build 26200.5600 released to DEV
by
joep517
3 days, 2 hours ago -
Windows 11 Insider Preview build 26120.3964 (24H2) released to BETA
by
joep517
3 days, 2 hours ago -
Drivers suggested via Windows Update
by
Tex265
3 days, 1 hour ago -
Thunderbird release notes for 128 esr have disappeared
by
EricB
21 hours, 57 minutes ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.