Auto-Email Alert Message

[ColinKJ]

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Can anyone help me.<o></o>
<o></o>
I'm putting together a project to automatically send emails remainders to our vendors when the insurance documents we hold of theirs for QA purposes have expired.<o></o>
<o></o>
To date, I've only used the Display function which has enabled me to check the content of the emails before sending them. This has worked fine.<o></o>
<o></o>
Now that I want them to automatically send, I get an Outlook alert advising me that an email is being sent and do I really want to send it. which I have to respond to before it is sent.<o></o>
<o></o>
The project I have put together is in XL, and the message is from Outlook, is there any way I can suppress the alert messages in Outlook from XL, restoring them once all emails have been sent.<o></o>
<o></o>
Your help would be appreciated.<o></o>

 

[VoG]

See if this helps http://www.rondebruin.nl/mail/prevent.htm

 

[ColinKJ]

Many thanks Vog,

I used the :

.Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%s"

option, and it appears to work fine for me.

Thanks again