Link to home
Start Free TrialLog in
Avatar of M A
M AFlag for United States of America

asked on

Send email from Excel based on value on drop down box

I need to send email excel file when I select the drop down menu.
For example
if I select inprogress in column L I need to send email Saying that "Item XXXX (Taken from value of column E) Part# XXX (taken from Column I) Ticket#XXX (Taken from column K) quantity X (Taken from H)  is sent out for delivery"
And if I select delivered in column L I need to send email Saying that "Item XXXX (Taken from value of column E) Part# XXX (taken from Column I) Ticket#XXX (Taken from column K) quantity X (Taken from H) is delivered"

Attached the excel file for your reference.
Appreciate your help.
EVERNEX-STOCK--GT-REF-.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Daniel Pineault
Daniel Pineault

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial