Automated E-Mail on updating the Excel Sheet

[kittu55]

Hi All,

I need some help regarding the below issue.

I have a shared excel file which would be updated by more than 1 user everyday. I need a macro that would send an automated e-mail to 5 recipients whenever any one update the sheet along with the data that is updated newly in the sheet in the body of message.

I use Outlook for e-mails.

Thanks in Advance.

[gmr4evr1]

Give this a shot.

Please Login or Register  to view this content.

You will have to change email addresses, possibly the IP address, the .Subject line etc., but this might get you started. Change the Me.Range to the column range you use, if its the same each time.

[kittu55]

Hi Tom

Thanks for the response.
Our IP is dynamic as we operate on a remote environment. Is there some other way to do this.

Thanks.

[gmr4evr1]

I don't know how to go about it if the email server is dynamic as well, you might have to get with your IT department for more info.