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

[Ced Jones]

Hi.
I regularly email Excel workbooks. To make it more convenient, I have
included [Application.Dialogs(xlDialogSendMail).Show ("(e-mail address removed)")] 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 ("(e-mail address removed)")] also requires a confirmation from
Outlook Express.
A solution to this hassle will be much appreciated.
Thanks in advance,
Jones.

 

[NoodNutt]

G'day Ced

You will find this link is what you are looking for

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

HTH
Mark.