select data using drop down list

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

Try:

It is woeking great. Thank you Mr.Paulked.

You're welcome :thumb

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....aq_req_help_pm for my reasons.

If you need further help, start a new thread.

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

Ron de Bruin has a great site for email with VBA here https://www.rondebruin.nl/win/s1/outlook/mail.htm