Results 1 to 5 of 5

Thread: Mail Shots (2K)

  1. #1
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Shots (2K)

    I am developing a db for the Careers department at my school. All Year 10 students (15 y o) spend 1 week in a work placement. I have set up the db successfully which produces a variety of reports based on queries. The year group is, on average, circa 350. The Careers department has to send out a number of standard letters to both parents and companies giving details of individual placements.
    My question is, would it be more efficient to use the db (queries) as a data source for a mail merge using Word, or to use the Report facilities of Access? Can Access even emulate a mail merge?
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail Shots (2K)

    The mail merge to Word is probably the best way to go. Access reports can be made to look like letters, but you are pretty limited in terms of text formatting, paragraph formatting and so on, even though the report is a more efficient process.

    If it's not a frequent task, you can simply run the merge from Word and use the appropriate query as your data source. If you do it more frequently you may want to consider using Automation in Access to drive the process - we have a tutorial on how to go about that on our website.
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Shots (2K)

    Thanks Wendell. You've confirmed my original thoughts. As a matter of interest, would you please clarify your expression <Automation in Access>? I've so much to learn, and although my adventures with Access have been both time-consuming and frustrating, they have also been very rewarding thanks to you and other loungers. I hope that in time, I can offer a little help to others.
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail Shots (2K)

    Automation is essentially running one application in another. It requires using VBA, and knowing the object model for the other application. So if you are driving Word from Access, you have to use the Word objects, methods, actions and so on. Do a search on "Automation" under Access 2000 in the MS Knowledge Base and you'll get a number of articles talking about it. We also hope to have a tutorial on the basics of Automation on our website in a couple of weeks.
    Wendell

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Mail Shots (2K)

    <<We also hope to have a tutorial on the basics of Automation on our website in a couple of weeks.>>

    Sounds like a great idea, one way to learn very quickly about this subject. Well done Wendell.
    Would you let us know when you put it there.

    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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