Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: How can I send an email to multiple email addresses through Outlook 2007

    I have a table called Info with a column called Email Address in it. I want to create a command button in a form called Customer ,which has the Info table as the Record Source, and I want this command to open up a new email window in Outlook 2007 and copy all the email addresses to the To field without forgetting adding a semicolon after each email

    How can I do that? or what is the VB code for such button?
    I'm not so good in Access but I have a little experience

    Any help will be greatly appreciated

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    You would have to use VBA to loop through the addresses to build the "To" string, then create the new e-mail address it etc.

    I seem to remember this question coming up a few times here.... You might like to try searching for it/them.
    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