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

    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
    Sender

    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.
    Thanks
    Paresh
    p.S I am not a developer.

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    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
    Posts
    2
    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
    Location
    Adelaide, South Australia
    Posts
    4,049
    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
  •