Notify when SEND complete

A

Andrew

I am sending a large number of emails using Excel VBA through outlook which works upto a point except that I want to close outlook after the job is done. If I include a close statement at the end of the routine (kindly stolen from a post provided by M Legault) any mail in the outbox doesnt get sent.

Is there a flag I can read to say when the application can be closed or is it just best to insert a time delay?

Many thanks

Andrew
 
Top