Thru VBA, how do I e_mail with ONLY ONE CLICK ?
 

Hi.
I regularly email Excel workbooks. To make it more convenient, I have
included [Application.Dialogs(xlDialogSendMail).Show ")] in my
code. That line is used about 5 times sending the book to differrent
recipients with various stages of confidentiality removed.
My gripe is this: I've got to click 'send' the 5 times times my default mail
server, Outlook Express, pops up.
[ActiveWorkbook.SendMail ")] also requires a confirmation from
Outlook Express.
A solution to this hassle will be much appreciated.
Thanks in advance,
Jones.

Thru VBA, how do I e_mail with ONLY ONE CLICK ?
 

G'day Ced

You will find this link is what you are looking for

http://www.rondebruin.nl/sendmail.htm

HTH
Mark.