#1
|
|||
|
|||
Mail Merge from Access DB
I have an access database with one large table and a number of queries. We merge using DDE.
Currently we process specific documents by opening a mail merge, navigating to the fiscal year, then selecting the database (which corresponds to this fiscal year), selecting the appropriate query, and then the correct item from that query. I'm creating a simplified visual basic user form with buttons to automate some other processes and I thought it might be useful to speed up the mail merge such that: 1) Select Fiscal Year from user form. 2) Hit 'go' and it automatically opens the data-base and displays the available queries. The user would then select the query and the item as usual. So I'm trying to set the database source with: ActiveDocument.MailMerge.OpenDataSource Name:=DBLoc, SubType:=wdMergeSubTypeWord2000, LinkToSource:=False, ReadOnly:=True The 'DBLoc' string shows the correct path in the debugger but the error I'm getting is: 'Word was unable to open the data source.' So I can't get any further with my experimentation. Why won't it open? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge - Many to One w/MS Access data | mklepper | Word | 1 | 03-07-2015 08:30 AM |
Mail merge from Access to Word | Matthew7 | Mail Merge | 1 | 02-18-2015 11:05 PM |
Mail Merge from Access Query to Word | ChrisMan | Mail Merge | 2 | 12-10-2012 11:22 PM |
Combine Records when Mail Merge from Access | Tom Pickles | Misc | 2 | 08-24-2010 06:00 PM |
Word / Access - Mail Merge | ibuilders | Mail Merge | 0 | 07-30-2007 06:18 PM |