Good evening,
I'm very inexperienced with VBA, but would like to be able to have Excel draft and send an email based on options selected from a dropdown. The subject of the email along with the body of the text also need to have values from cells inserted.
For example: "Yes" selected from Dropdown in E2
Outlook opens
Email subject: "Order # (C2) Completed
Email Body: This is confirmation that Order #(C2) was completed. Total quantity completed is (F2)
I'm very inexperienced with VBA, but would like to be able to have Excel draft and send an email based on options selected from a dropdown. The subject of the email along with the body of the text also need to have values from cells inserted.
For example: "Yes" selected from Dropdown in E2
Outlook opens
Email subject: "Order # (C2) Completed
Email Body: This is confirmation that Order #(C2) was completed. Total quantity completed is (F2)