+ Reply to Thread
Results 1 to 7 of 7

macro to send email.subject,body,email address are in 3 cells

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    27

    macro to send email.subject,body,email address are in 3 cells

    Hey guys,

    I have a workbook that calculates totals, and inputs them into a paragraph which is in cell C1, and the subject line is in cell B1. the email address is in cell A1.

    looking for a macro to send an email to the address in A1, with the subject line B1, and the Body in C1.

    can someone please help me out.

  2. #2
    Forum Contributor ianh's Avatar
    Join Date
    11-19-2010
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    114

    Re: macro to send email.subject,body,email address are in 3 cells

    Please Login or Register  to view this content.
    you can change the .send to .display to preview insted of sending
    Last edited by ianh; 12-02-2011 at 11:24 AM.

  3. #3
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: macro to send email.subject,body,email address are in 3 cells

    No need for a macro. Use the HYPERLINK function in whatever cell suits your layout needs.

    =HYPERLINK("MAILTO:" & A1 & "?subject=" & B1 & "&body=" & C1,"Send Mail")

  4. #4
    Registered User
    Join Date
    12-02-2011
    Location
    toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: macro to send email.subject,body,email address are in 3 cells

    Quote Originally Posted by ianh View Post
    Please Login or Register  to view this content.
    you can change the .send to .display to preview insted of sending
    ______________________


    This is perfect!

    one more question, for cc, and bcc, is this possible?

  5. #5
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: macro to send email.subject,body,email address are in 3 cells

    For what it's worth:

    =HYPERLINK("MAILTO:" & A1 & "?cc=" & B1 & "&bcc=" & C1 & "&subject=" & D1 & "&body=" & E1,"Send Mail")


    The code would be:
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-02-2011
    Location
    toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: macro to send email.subject,body,email address are in 3 cells

    perfect!! thanks so much!

  7. #7
    Forum Expert Whizbang's Avatar
    Join Date
    08-05-2009
    Location
    Greenville, NH
    MS-Off Ver
    2010
    Posts
    1,395

    Re: macro to send email.subject,body,email address are in 3 cells

    If you are satisfied with the solution, please mark the thread as solved. Instructions on how to do so are in the forum rules.

    Also, if you are pleased with the feedback of any member, in this thread or other threads, please consider adding to the member's reputation by clicking on the scales icon on the top right of the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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