Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    73

    Unanswered: Sending Emails with different criteria in Access

    Hi i'm trying to send emails in Outlook 2000 via Ms Access 2000. How do you write in the Subject of an email and in the body part?

    The information will be coming from a query so different customers have different information. There are 4 different email templates it can be, providing what criteria i want the customer to get that email.

    Eg

    Email 1 - Wrong Address
    Email 2 - Order Processed
    Email 3 - Refund
    Email 4 - Discount

    Its like a mail merge document but i need the information to be emailed in MS Outlook 2000.

    Do you have any ideas please

    Thanks in Advance

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Maybe the example here: http://www.dbforums.com/showpost.php...2&postcount=46

    will help (modifying it to meet your needs). For example, you could add a field to the lookup email addresses table which dictates what email template is sent for each email address.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jan 2002
    Location
    London
    Posts
    73
    Thanks for your suggestion i found this other link on the internet which was usful and it work

    http://www.granite.ab.ca/access/email/recordsetloop.htm

Posting Permissions

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