Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create email when the cell value changes
I want to create an email when the value in column A changes. In column A I
have the email addresses of managers. When the email address changes I want the VBA to compose the email and get the employees names in column B associated to that email address. I don't want it 1 for 1. I want to take only that one email address and bring in that range of employees in to the email. So in the example below I want to email and have employees 1,2,and 3 in thebody of the email. I don't want seperate emails for each employee going to the manager. Thanks Example: Column A Column B employee1 employee2 employee3 employee4 employee5 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
Sending to email different email address based on cell value | Excel Programming | |||
Macro for Email - Sending to email addresses in cell | Excel Programming | |||
How do I create an email macro to auto fill the email? | Excel Discussion (Misc queries) | |||
Email Range of Cell Content to create subject and body from link | Excel Programming |