PDA

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



elsuji
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

paulked
12-27-2019, 11:03 AM
Try:

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

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

paulked
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.

elsuji
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

paulked
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