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.