Hi Everyone,
So I have below a data table in excel and I've been trying to figure out how to have macro send an email notification to a specific group email once that user clicks from the drop down menu Yes in the completed column section but once the code is triggered it would pop up outlook new message window so they can use their own personal email address in Outlook. (Hope that made sense).
To: group@abc.com
Subject: Task Completed
Body: The task has been completed by the assigned user as of "today's date"
I'm using microsoft outlook and office 365
Any help will be much appreciated.
If you need more clarity please let me know.
Thank you!
So I have below a data table in excel and I've been trying to figure out how to have macro send an email notification to a specific group email once that user clicks from the drop down menu Yes in the completed column section but once the code is triggered it would pop up outlook new message window so they can use their own personal email address in Outlook. (Hope that made sense).
| Status | Completed? | Notes |
| Yes | ||
| Yes | ||
| In Process | ||
| Waiting | Waiting on other assignments to be completed. | |
| Yes |
To: group@abc.com
Subject: Task Completed
Body: The task has been completed by the assigned user as of "today's date"
I'm using microsoft outlook and office 365
Any help will be much appreciated.
If you need more clarity please let me know.
Thank you!
Last edited by a moderator:
