Can Excel send automaticaly e-mails depends on cell value

B

Booker

Dears.

Hello, I have question about automaticaly sended e-mails by Excel. If I have
a some worksheet which is analyzing data, can Excel send automaticaly e-mail
to someone if result of analyze is wrong (out of limit for example). It means
Excel will send e-mail depend on cell value.

Thanks in advance. (sorry for my english)
 
S

ShaunM

Hi

You should be able to acheive your request without too much trouble i
you are familar with vba.

You will need to setup a macro to check the cells value and then us
excels mail tools to send the email.

Look here for some very good example
http://www.rondebruin.nl/sendmail.htm

Regards
Shau
 
B

Booker

Thanks for reply.

I tried scripts from link above, but I'm not familiar with VB and scripts
is'nt helpfull for me.

Can someone prepare sheet with working example.

Thanks.
 
Top