I need help. I am a rookie to excel and I would like excel to send an email everytime there is a change made to the drop down cell of my excel sheet.
I will have 12 work sheets one for each month.
Each worksheet will be the same.
Work sheet will contain the following Cells
Property Name, Month, Date, Product Name, Serial Number, Product Number, Product Type, Company, Website URL, Quantity, Reason For Order, Product Status (Drop Down cell containing Product Requested, Product Ordered, Product Received).
Basically I want excel to send an email to email@example.com any time the Product Status is changed.
Subject Line of the Email Should Be: <MyCompanyName> Supply Chain - there has been an update to your Order Form for the <Property Name> for the Month of <Month>
Email Body: Should only display the information of the row of which the product status was changed.