Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge not running properly from Access Function but runs properly when opened manually
Here's the deal:
All of this is using the Office 2000 Suite. We've got an Access db in which we've got a button setup to open a particular document in Word and populate the Word document with information from a query contained in the db. Once the document opens, the access query runs and populates the document via Mail Merge. The problem lies in that when you use the button to open the document, the results of the query aren't "refreshed" into the document. (It pulls old data - one record set in particular over and over and over again). If you go and look at where it's pulling the information from in Access, the record set that the document is referring to isn't listed. We have a query setup to pull the desired information and the Word document just looks at the qry when it opens. If you look at the qry results before opening the document via the button, it contains the current information. If, however, you go and manually open the document, you get an alert that the query needs to run for proper use of the document. After allowing the document to run the query, the document is then properly populated with the correct information. I've gone around and around. From what I can tell, the problem lies in the word document as we're simply calling a function to open the document with the desired filename. The qry is pulling the correct info before and after opening the document - its just that the document isn't populating itself w/ the query results when its opened via the code in access. Thanks for the help! |
#2
|
|||
|
|||
I'd guess that there is something wrong with your Access procedure.
Take a look at the "Super easy Word merge" item on fellow MVP Albert Kallal's website at: http://www.attcanada.net/~kallal.msn.../msaccess.html -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "Brian Alley" BAlley atctsinetdotcom wrote in message ... Here's the deal: All of this is using the Office 2000 Suite. We've got an Access db in which we've got a button setup to open a particular document in Word and populate the Word document with information from a query contained in the db. Once the document opens, the access query runs and populates the document via Mail Merge. The problem lies in that when you use the button to open the document, the results of the query aren't "refreshed" into the document. (It pulls old data - one record set in particular over and over and over again). If you go and look at where it's pulling the information from in Access, the record set that the document is referring to isn't listed. We have a query setup to pull the desired information and the Word document just looks at the qry when it opens. If you look at the qry results before opening the document via the button, it contains the current information. If, however, you go and manually open the document, you get an alert that the query needs to run for proper use of the document. After allowing the document to run the query, the document is then properly populated with the correct information. I've gone around and around. From what I can tell, the problem lies in the word document as we're simply calling a function to open the document with the desired filename. The qry is pulling the correct info before and after opening the document - its just that the document isn't populating itself w/ the query results when its opened via the code in access. Thanks for the help! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge not working properly | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Web-Site-based Word Mail Merge & Access DB | Mailmerge | |||
mail merge and access query | Mailmerge | |||
Word mail merge with Access | Mailmerge |