Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Leesburg, Virginia, USA
    Posts
    618
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email from Access (Access XP)

    Is it possible to sort an Access database by zipcodes and then send an email from Access thu Outlook for a selected Zipcode?

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

    Re: Email from Access (Access XP)

    There are a couple of ways to solve the problem. The first uses Automation to create emails in Outlook for the recordset of a query that restricts the data to a single or set of zipcodes. It requires significant knowledge about VBA and the object models of both Access and Outlook, but gives you the most freedom in creating an email. The other approach is to do a Mail Merge in Word, using the same Access query as the data source, and specifying email as the output source for the merge. Either assumes you have the email address stored in an appropriate table and this is a part of the query results. If you want further details on either approach, you can use the Search feature of the Lounge, or post back. It's a question many people have.
    Wendell

Posting Permissions

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