Share via

Automatically send email based on cell range changes

Anonymous
2019-11-07T22:05:09+00:00

I want to automatically send an email to a group of employees when a cell range has been changed.

In Column B4:B12 I have the name of each server environment we have.  in Column E4:E12 I have the date that the environment was refreshed.

For example:  If I change the date in E4, then I want an email automatically sent to the people in IT that the refresh date has been changed for the server environment in B4, etc, etc, etc.

Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-11-08T03:48:48+00:00

Hi Keith Phillpott,

I go through your Post, there cloud be no such feature in Excel that can meet your requirement directly. However, there is a VBA code which may help you, I have tested it on my side, and it works. Please note the NOTES in this article: How to send email if a certain cell is modified in Excel?

***Disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

Hope these can help you.

Regards,

Clark

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-11-11T20:53:48+00:00

    Hi Keith Phillpott,

    Has information above helped you out?

    Regards,

    Clark

    Was this answer helpful?

    0 comments