Can Excel send automaticaly e-mails depends on cell value

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top