Results 1 to 2 of 2
2004-03-29, 10:21 #1
- Join Date
- Mar 2004
- Thanked 0 Times in 0 Posts
Autmatically saving a merged in Word (Access2K)
I have an access database in which an event attached to a command button calls a word document for merging based upon a query. I would like to know if there is a way to save this document automatically in a preset folder using say the Merged File name and the FileNoId which is eneterd as a parameter in the query.
2004-03-29, 10:41 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Autmatically saving a merged in Word (Access2K)
You need to use Automation to control Word from Access. If you initialize the merge using the standard RunCommand acCmdWordMailMerge command, it may be difficult to obtain a reference to the correct document. I would use Automation to perform the entire merge operation, you have complete control over the document then. See Managing Merges with Access and the links in that tutorial on <!profile=WendellB>WendellB<!/profile>'s website.
If you search the Access board for mailmerge, you'll find several posts containing example code.