Results 1 to 1 of 1

Send an Email, allow user to add CC, input message text, receive confirmation

Threaded View

Khowailedg Send an Email, allow user to... 02-07-2013, 06:08 PM
  1. #1
    Registered User
    Join Date
    01-29-2013
    Location
    Washinggon, DC USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Send an Email, allow user to add CC, input message text, receive confirmation

    Hello,

    I am using this very basic macro to save and send my excel to a defined e-mail address.

    Sub Email()
        ActiveWorkbook.SendMail Recipients:="xx@gmail.com"
    End Sub
    And it works fine, the only thing is user gets no chance at all to contribute to that e-mail. I would love if the macro allow the user to

    1)Input text in the e-mail body if desired
    2)Add e-mail account to the CC or the BCC section
    3)Receive some kind of confirmation for the sent mail.

    Is that even possible, I appreciate your help.

    THANKS
    -
    Last edited by JBeaucaire; 02-08-2013 at 04:02 AM. Reason: Added code tags, as per forum rules. Don't forget!

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