Results 1 to 2 of 2
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Mail Merge or Automation (Word/Access 2000)

    We currently have a client who runs a number of one-record mail merges, some of which have quite a bit of logic embedded in the Word main document, from their Access database on a frequent basis. I suggested they consider using the Automation approach where we simply push out data to a Word document, as my experience suggests it is a fair bit faster than doing a Merge. They seem somewhat reluctant to abandon the mail merge approach, so I'm looking for opinions from others as to the pros and cons in this situation.
    Wendell

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mail Merge or Automation (Word/Access 2000)

    What I've done in the past is export the merge data to a format that Word can read as a table. I set up the merge template with its datasource as the export file, and that saves having to reconnect the document when the source file is overwritten by the next export. That allows them to run their mail merge from Word without the extra overhead of Access as well.
    Charlotte

Posting Permissions

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