Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009

    Unanswered: Help sending custom emails to contacts in Access 07 db


    First of all, thanks to the experts for being willing to help those of us with far less skill!

    I have an Access db with contacts (names, emails) and titles of papers that the contacts have written.

    I want to send each of the contacts (identified through a query) a customized email that includes the title of his/her paper, along with a brief note (the same for each person). Basically:

    Dear ("FirstName"),

    This is a quick note to remind you to submit your paper, ("title")

    Thank you,

    I've searched the Code Bank, but didn't find anything that might help. It's probably there, but...

    Sadly, I figured out how to do this years ago in Access 97, but that was long ago and I've forgotten. I know that I can send a report using the SendObject function in a macro - but not how to customize an email.

    Any help would be much appreciated.

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    Here's one example from the code bank if you haven't seen it already:

    I believe also this example: (or maybe it is this one: It's the last mdb example (ie. SearchFormMultipleWaysHighlightCurrRecNewVersion.z ip) - Look at the FindBusiness2 form. - I like this form as it works very well for sending emails! Give it a try.

    It has a "search" form in it which let's you "search" as well as email (it works kind of neat). Either way, the code may be beneficial but chances are you'll need to modify it to work with a query to send emails to "everyone".
    Last edited by pkstormy; 03-30-09 at 12:35.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Personally, I use this kind of solution to that problem.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Mar 2009

    Working! Thanks!

    Thanks StarTrekker and pkstormy. I'm working with both suggestions at the moment - I like the business2 form and can see a lot of future use for it.

    The sending email through SMTP code is beyond the boundaries of my current abilities, but believe that it's worth trying to sort out.

    I really appreciate the guidance here.

Posting Permissions

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