View Full Version : [SOLVED] select data using drop down list

12-27-2019, 10:45 AM
Dear Team,

I am having data (Name and Email ID) from Sheet 2.

In sheet 2 names listed on B6:B23 and Email Id listed on C6:C23.

In Sheet1 "D1" i had created drop down list of names. When i am select name on drop down list on D1 the email is should display on G1.

For example, I select the name which is on Sheet2 B6, the email id should display from C6. If i selected B9 then email id should display from C9.

Can any one help to create code for the above condition.

My file is attached with this mail for reference

12-27-2019, 11:03 AM

12-27-2019, 11:28 AM
It is woeking great. Thank you Mr.Paulked.

12-27-2019, 11:30 AM
You're welcome :thumb

12-27-2019, 11:57 AM
Please respect this forum and its' members, I won't answer your question in your PM to me. Please see here http://www.vbaexpress.com/forum/faq.php?faq=psting_faq_item#faq_req_help_pm for my reasons.

If you need further help, start a new thread.

12-27-2019, 12:13 PM
Dear Paulked,

I apologize to send PM message.

I have one more query.

When i am selecting the name on the drop down list it is filter the name as per my selection and the email id also displaying.

I want the filtered values send by outlook email to the email address which is displaying on G1.

Can you please help me for this

12-27-2019, 12:24 PM
Ron de Bruin has a great site for email with VBA here https://www.rondebruin.nl/win/s1/outlook/mail.htm