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
-
Bookmarks