i am trying to create a mailto link in excel
a drop down list will have peoples name and when that persons name is selected it should send an email to that person using outlook

I created a drop down list with hyperlinks using a combo box

Cell A1 =HYPERLINK("mailto:[email protected].","Tom")
Cell A2 =HYPERLINK("mailto:[email protected]","Pan")

i gave A1 and A2 a range name Hyperlinks
and named B1 L_C

then i created a combo box and added input range as Hyperlinks and Cell links as L_C

then i added macro to the combo box
and wrote the following 

Please Login or Register  to view this content.