Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Leesburg, Virginia, USA
    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
    Evergreen, CO, USA
    Thanked 58 Times in 58 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.

Posting Permissions

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