Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Posts
    26

    Unanswered: E-mailing individual records

    I would like to send individual e-mails to each person in my query. How would I do that? Thanks in advance

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    I see that no one is touching this one with a 10 ft pole ... Do the words "Vague Requirements" mean anything????? A literal answer to this post can be YES. Anyway that you want to do it ... 2 or 3 ways come to mind ... What did you have in mind?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Feb 2006
    Posts
    26
    Let's say I have a query result that gives me records with payments that I need to send to individual e-mail addresses for instance:


    $10000 cbett@att.com
    $20000 kbett@att.com
    $100000 dbett@att.com

    How would I code this so I could click a button and have each record sent to the e-mail address?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Betty2
    Let's say I have a query result that gives me records with payments that I need to send to individual e-mail addresses for instance:


    $10000 cbett@att.com
    $20000 kbett@att.com
    $100000 dbett@att.com

    How would I code this so I could click a button and have each record sent to the e-mail address?
    Access version? Host email client? There are numerous ways ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Emailing

    Maybe the attachment might show you one way you can do it.
    Attached Files Attached Files
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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