Sending emails

Yes i have read Ron de Bruin's tutorials.

Hi,
I'm trying to send sheets to an email.
My code up to now saves a copy of the sheet in a file, and I send that file out.
Unfortunatly when I run my macro it ends with the email opening, the file being attached, and I need to input the email adress. Also, i need to automatically overwrite what is in the folder.

My code looks nothing like the one on Ron's tutorials.
can anyone help out:

Please Login or Register  to view this content.

In the 2nd code you're not actually doing anything with the Item you're creating, ie you're missing any one of:

Please Login or Register  to view this content.

prior to the End With statement... the first will mail, second will show dialog and third will save as draft.

Regards the first code, if you just want to send it and are not fussed about setting Body content then use ActiveWorkbook.SendMail method.

Regards Security Prompt... I would refer you to Ron de Bruin's site but...

His site really does cover all the options open to you... http://www.rondebruin.nl/mail/prevent.htm

Other than those mentioned there's not a huge amount you can do I'm afraid.