Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2008

    Unanswered: How can I send customized emails from Access?

    Hello all.
    This is my first posting on this forum.
    I have a MS Access database that has all contact information.
    We want to send customized email from this.
    What we want to do is to be able to have something like this:

    Dear <Salutation>,<Fname>, <Lname>
    Text of the email goes here
    Thanking you

    We want the Salutation, fname and lname to come from the database's contacts table columns with similar names.

    Not sure if I asked the question correctly or not, so please help me if you can.
    p.S I am not a developer.

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    Look in help for 'sendobject'. If you don't need fancy formating in the email body, it should do what you want.

  3. #3
    Join Date
    Feb 2008
    Thank you Rogue.
    It is going to be tough for me since I am not a developer.
    If there is any pre-existing code I can use that would be better.
    But I promise, I will try.

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    I'm pretty sure the code bank has at least one example of sending mail.
    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

Posting Permissions

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