Send email when a Cell value is less than a number

[brijeshkeni]

Dear All,


Can you please advise if an email can be sent automatically to a person; if a call value reaches below a limit.

can this be possible


Best Regards,

Brijesh Keni

 

[bobhc]

Good day brijeshkeni

You may find the upload of use


https://dl.dropbox.com/u/75495784/ChangeEventMailOutlook.xls

 

[Gungnir5]

great worksheet bobhc. thx!

 

[bobhc]

Good day all


This is not my work......but if you would like to know more visit the authors site,


http://www.rondebruin.nl/sendmail.htm

 

[Ajinkya]

Hi bobhc/Gungnir5,


I have checked the file "ChangeEventMailOutlook.xls"

Its really amazing, could you pls let me know, how can i change my mail draft body and add signature.

exactly i want to know how can i add my subject line, text body and signature.


Ajinka

 

[kuldeepjainesl]

Thanks for sharing this BOBHC.....

 

[bobhc]

Good day Ajinkya

If you go in VBA and look on the left for the Modules and open it up, open up the Mailcode, in the right hand side window you can alter the code as required, if you read it once or twice you will soon see where to do this.

 

[Ajinkya]

Yup dear, got it. thanks for...