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

Can you give more information

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


--
Regards Ron De Bruin
http://www.rondebruin.nl



wrote in message ups.com...
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

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 wrote:
Can you give more information

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


--
Regards Ron De Bruin
http://www.rondebruin.nl



wrote in message ups.com...
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

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


--
Regards Ron De Bruin
http://www.rondebruin.nl



"jsmg" wrote in message oups.com...
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 wrote:
Can you give more information

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


--
Regards Ron De Bruin
http://www.rondebruin.nl



wrote in message ups.com...
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