Send Excel File with VBA

[RoxyAES]

Hello All,

I have been searching through various forums for awhile, and not finding the exact coding needed.

I have an excel file which I would like to have a button will send the active sheet as an attachment.

The main factors I need are:

-Send to
-CC
-Subject (is it possible to choose one cell from the form to be the subject?)
-Attach the active sheet

Send the email, without the security promt asking if I want to send the mail or not and just send the mail directly.

Any input would be greatly appreciated!!!

Thanks!

 

[JamesW]

Hi,

Which mail system are you using (Outlook, Notes etc)?

http://www.codeforexcelandoutlook.com/excel-vba/send-email-from-excel/ - Outlook
http://www.bygsoftware.com/Excel/VBA/email_from_lotus_notes.htm - Lotus Notes