Question about Nimrod email code

[babycody]

Nimrod provided the following code in another post:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) 
ActiveWorkbook.SendMail Recipients:="EmailAddressHere" 
End Sub

I was curious if it were possible to add a few more features to the code?
1. Currently it creates an email message before saving. Can code be added to have it create an email apon closing also?
2. Can Cc and Bcc be added to this?
3. Can a subject line be added?
4. I am most curious as to the possibility of bypassing the popup that ask send or don't send. Can code be added so that the email is sent without any confirmation?
5. How would I go about putting multiple email addresses into the main, Cc, and Bcc?
Thanks for any time you give toward this. I have viewed several post on the subject of emailing. I have followed a lot of links, but haven't found one that incompassed all aspects listed above. I tried to incorporate bits of code into one with no success. Just a VBA novice.

 

[Ekim]

The above macro uses the SendMail syntax. With SendMail, it is not possible to:
1) Send text in the Body of the mail
2) Use the CC or BCC field
3) Attach other files

(source: http://www.rondebruin.nl/mail/folder1/mail1.htm)

However, there are alternatives. As a starter, see the various email macros authored by Ron de Bruin (Microsoft MVP): http://www.rondebruin.nl/sendmail.htm

Another good source of email macros is **** Kusleika’s web site: http://www.dicks-clicks.com/excel/olSending.htm

See if there is any macro from the above sites that come close to what you need. If so, it may be possible to amend the macro to do exactly what you want.


HTH

Mike