+ Reply to Thread
Results 1 to 6 of 6

Excel to send email to two addresses in two cells? MSG box upon send?

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Excel to send email to two addresses in two cells? MSG box upon send?

    Hi All,

    I'm very new to VBA. I've made a simple form in excel for users to fill out with their information and their email address and their teammates email address. There is a button for them to click to send it in an email to a mailing list. I need to CC both email addresses provide and they are in different cells.

    I've used the tips on http://www.rondebruin.nl to get as far as I have, but I'm not able to get the the email to send to two email addresses when they are in different cells.

    I've also tried to get a validation check to run on the fields to make sure everything field has been completed before the email will send, but I can't figure that out either. Also, I would like a message to appear after the user clicks the submit button(like "This request has been submitted"), however, I can't figure out how to get this to work.

    I've read through so many of the threads on here and tried so many of them. I've been working on this for 3 days, I think I am going crossed eyed! any help is much appreciated!

    Here is my code:
    Please Login or Register  to view this content.
    Last edited by sdyer02; 07-15-2016 at 05:16 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,531

    Re: Excel to send email to two addresses in two cells? MSG box upon send?

    Welcome to the forum.

    Try:

    Please Login or Register  to view this content.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    07-15-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Re: Excel to send email to two addresses in two cells? MSG box upon send?

    AH! thank you so much! It worked!

    I've updated my original post to include the code tags. Sorry about that! I'm going to thoroughly read the rules now.

    If anyone can help with my messaging issue or validation check... please let me know!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,531

    Re: Excel to send email to two addresses in two cells? MSG box upon send?

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-15-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    3

    Re: Excel to send email to two addresses in two cells? MSG box upon send?

    Thank you so much TMS! it worked!

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,679

    Re: Excel to send email to two addresses in two cells? MSG box upon send?

    Please Login or Register  to view this content.
    Only disadvantage of this method is that when you want to send to more then 2 addresses your string will become really long.
    That's why I would like to propose this alternative.
    Please Login or Register  to view this content.
    which you can easily expand just by replacing d6 with the last cell in the range you want to use.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. I send email using Lotus from Excel but how to send from Thunderbird?
    By EvelynLoh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2015, 11:31 PM
  2. [SOLVED] Macro to open Outlook and send one email to multiple addresses from excel columns
    By telcocook in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2015, 10:11 AM
  3. Replies: 1
    Last Post: 09-09-2013, 03:46 PM
  4. Automatic send email (without even click send in mail software) with excel vba ??
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-17-2013, 08:31 PM
  5. Replies: 2
    Last Post: 01-06-2010, 06:12 AM
  6. How to send the same form to different email addresses using macros?
    By kjdemeyer in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2009, 03:06 PM
  7. send email with email addresses in a range of cells
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2005, 05:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1