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
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
Microsoft OfficeVBAMicrosoft ExcelVisual Basic Classic
Last Comment
Daniel Pineault
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.