Another Excel Question

[richy22]

Seem to be a lot of these popping up!

I have a worksheet and what I want to do is email 4 or 5 people once the sheet has been updated or saved. Is this possible??

I already have a nifty little thing that logs, on a separate sheet, what user saved the sheet, time date, what they put etc etc but I also want to just send an email with something like..

"The file has been updated"

Any ideas or websites anyone can point me too?

 

[JoedotwasT5phy]

Don't think it can be automatically done.

Would be feking handy if it could though.

 

[richy22]

It is done Okay il elaborate! I found a site that goes through a few things and just tested it out... seems to work

 

[JoedotwasT5phy]

It is done Okay il elaborate! I found a site that goes through a few things and just tested it out... seems to work

Linky - wouldn't mind that!!

 

[richy22]

Here you go....

Im still trying to finalise it though as I want it to email when the worksheet has been saved... at the moment I have to run the macro and the nit sends but the principle is there.

Links....

http://www.mrexcel.com/forum/showthread.php?t=348927

http://www.mrexcel.com/forum/showthread.php?t=363089&highlight=send+mail+when+sheet+has+been+saved

Also some interesting stuff on here as sometimes you can have error messages etc...

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

http://www.rondebruin.nl/mail/change.htm

 

[JoedotwasT5phy]

Thanks

 

[richy22]

No problem... I have got it all working now when the document is saved... if you want any help with any niggly bugs let me know as im sure I would of worked through them!

I didn't realise it could do some of this stuff!

 

[JoedotwasT5phy]

Cheers Rich. I'll give it a bash next weekn and drop you a pm if i need a hand.

Cheers