Automation of spreadsheet E-mailing

[Steve Wright]

Hi All

I have managed to set up a spreadsheet that is emailed to a list of people
at the push of a button but have been unable to solve an annoying problem
with a popup box generated by MS Outlook.

The popup box seems to recognise that the Item to be mailed has been
generated by VBA and then requires a wait period of 5 seconds befor allowing
the Yes button to be pushed and the mail message to be sent.

I would like to bypass this, preferably by turning the feature of and back
on again form within the Excel VBA code. Ie. I do not want to loose the
Outlook functionallty apart from when I run my code in Excel.

Does anyone have a solution to this that I can try?

TIA

Steve