Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Dec 2002
    Kitchener, Ontario, Canada
    Thanked 0 Times in 0 Posts

    Automation Access to Word (2000(SR3))

    I am working on a database to store information for worship bulletins and also output elements of a television script for our weekly broadcasts. These need to go into Word so that they can be edited after the fact. The idea is to speed up data input and centralize the entering of that data. I have been playing around with using bookmarks and a template with Automation and am also looking at using a mailmerge (although I have only ever done this manually from Access).

    There are about 30 - 50 fields that will be outputted on a weekly basis and for the script, many of them will be memo fields.

    My question: Are there advantages to using Mailmerge over bookmarks or vice versa? The bookmarks seem pretty straightforward to use in VBA but I'm wondering if there are downsides, particularly with the memo fields that I need to be aware of. I want to set it up that the secretary chooses the week they want to prepare and click a button. Ideally I don't want her to have to answer a lot of questions from a Mailmerge wizard which is why I like the bookmark approach. Simple typing from Access to Word.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Automation Access to Word (2000(SR3))

    Both methods work well. If you're comfortable with using bookmarks, I'd stay with them.

    (BTW, mail merge can also be controlled completely from VBA)

Posting Permissions

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