Link to home
Start Free TrialLog in
Avatar of LUIS FREUND
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
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Will recipient's email id be the same for each name selected from the drop down?
Or you would setup a lookup table with names and their emails on a separate sheet?
Avatar of LUIS FREUND
LUIS FREUND

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
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

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
AWESOME!   Thank you very much for this!  Works as advertised.!
You're welcome Luis! Glad it worked as expected. :)