invoking a add-in with an if statement

[jcrowhurst]

Ladies and Gentlemen,

Your help please.....

I'm pretty good with excel, but have not ventured too much in to
Macros, or VBA.

I need to run an add-in (specifically sendmail) based on inventory
levels in my excel spreadsheet.

I was thinking that I could use the 'if' statement, but apparently I
was wrong.

Any help, whether it be with a Macro or the continued use of the if
statement would be greatly appreciated.

Thanks
-Jason

 

[Ron de Bruin]

Can you give more information

For mail code see
http://www.rondebruin.nl/sendmail.htm

 

[jsmg]

I'm working on a Inventory management spreadsheet and trying to set up
a 're-order' point. When inventory levels reach a predetermined point,
I'd like excel to automatically (either upon closing the spreadsheet or
upon reaching said point) to automatically send an e-mail to several
people.

I copied your code and pasted it into a module, made my modifications
(correct e-mail address etc..) and need to know what I should do
next....

Thanks for your help!

 

[Ron de Bruin]

Which macro you choose ?
Do you want to send one mail to more people or a seperate mail to each person