M
Mike L.
how do I link an email address to a specific selection in a dropdown list?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
What kind of dropdown (data|Validation, a combobox from the Control toolbox
toolbar, a dropdown from the Forms toolbar)?
And is it placed on a worksheet or is it a combobox in a userform?
And what version of excel are you using?
(I think you'll need a little VBA in any case.)
toolbar, a dropdown from the Forms toolbar)?
And is it placed on a worksheet or is it a combobox in a userform?
And what version of excel are you using?
(I think you'll need a little VBA in any case.)
D
Debra Dalgleish
If you have a list of names and email addresses in your workbook:
Name Email
Al [email protected]
Bea [email protected]
Cal [email protected]
Use data validation to create a dropdown list of the names (in cell B3
in this example).
Then, in an adjacent cell, use a Hyperlink formula to create the email
address, e.g.:
=HYPERLINK("Mailto:"&VLOOKUP('Data Entry'!B3,NameLookup,2),B3)
Name Email
Al [email protected]
Bea [email protected]
Cal [email protected]
Use data validation to create a dropdown list of the names (in cell B3
in this example).
Then, in an adjacent cell, use a Hyperlink formula to create the email
address, e.g.:
=HYPERLINK("Mailto:"&VLOOKUP('Data Entry'!B3,NameLookup,2),B3)
D
Dave Peterson
After reading Debra's post, I'll change this line:
(I think you'll need a little VBA in any case if you want to follow that link
when you change the dropdown.)
to(I think you'll need a little VBA in any case.)
(I think you'll need a little VBA in any case if you want to follow that link
when you change the dropdown.)