Auto email response/Help me

[Mark1ace1]

Worksheet Number 2, has Column B6:B14 customer name, Column E6:E1
status "OK" or "Overdue", column F, F6:F14 has an email address...

I want to create an automatic email. If E6:E14 states "Overdue" the
send an email to that email address, to that particular customer..

Thanks

Mar

 

[Dave Peterson]

Ron de Bruin has lots of sample code at:
http://www.rondebruin.nl/

And Dick Kusleika has some (especially Outlook) at:
http://dicks-clicks.com/excel/olAutomating.htm