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.