LUIS FREUND
asked on
Email Excel WB by selecting name from a dropdown list to Outlook.
What I was looking for is to email the WB by selecting the name from a dropdown list and click on a button to send to outlook.
I've attached the WB as an example. On cell N3 there is a dropdown box and by selecting the name and clicking on the "email button" it would send the WB to Outlook and populating the subject line with for example, " ART ready for disposition" to the email address selected from the Dropdown box.
The names are just examples...for ease of simplicity it'll be something like John.smith@Gravy.com, Luis.Smith@Gravy.com...and so on
C--Users-lfreund-Desktop-ART-EMAIL.xlsm
I've attached the WB as an example. On cell N3 there is a dropdown box and by selecting the name and clicking on the "email button" it would send the WB to Outlook and populating the subject line with for example, " ART ready for disposition" to the email address selected from the Dropdown box.
The names are just examples...for ease of simplicity it'll be something like John.smith@Gravy.com, Luis.Smith@Gravy.com...and
C--Users-lfreund-Desktop-ART-EMAIL.xlsm
ASKER
Perhaps a lookup table with names and email address on a separate sheet would be a great idea since it will change often.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
AWESOME! Thank you very much for this! Works as advertised.!
You're welcome Luis! Glad it worked as expected. :)
Or you would setup a lookup table with names and their emails on a separate sheet?