Results 1 to 2 of 2
  1. #1
    New Lounger
    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.

  2. #2
    Plutonium Lounger
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts