Send Email Using MACRO

[Nico Learning]

A                B              C                    D
1 [B]Staff     Team Manager      Coaching      Urgency[/B]

2 Jon              Mark              Sales          Urgent
3 Sam             Steve            Billing          Non Urgent
4 Jacob           Mark              Collecting    urgent
5 Susan           Emma            Sales          Urgent

Hi All,

Im not sure if this can be done but hopefully some one out there will be able to help me, i have created an example of the spread sheet above hopefully its clear enough,

Is it possible to send an email to a particular email address when each time a cell is been updated and the save button is clicked? example if Cell "A6" has been updated then an email will be sent to: "132@xyz.com",

Also i have two different email address so its depending on the team manager that update the spread sheet then the email will be sent to a different address, e.g. if Emma and Mark update the Spread sheet then the email will go to "132@xyz.com" but if Steve update the Spread sheet then the email will go to "789@abc.com".

Really appreciate it if this can be done

Thanks
Nico

 

[wigi]

How do you determine who updates the spreadsheet? Can the code check for Application.UserName ?

 

[Nico Learning]

Hi Wigi,

There is only a set of people that will update the spread sheet so i would have to enter there names in the code, so if Emma, mark update it then it will go to 1 email address, but if Steve or Luke up date it then it will go to the other email address, (only team managers can up date the spreadsheet, and they will enter their names in column "B") and yes it can have userName

Thank you for you speedy reply