I have a drop down where the user can select a name form the list which runs an Access query to return an email address for the selected person.
I need the email address to be shown as a clickable hyperlink to open a new email and to be entered via VBA code which works on the Worksheet_Change event
The new email doesn't need any subject or body text and just needs to be to the email address that is returned from the Access query
I can see that you can use the HYPERLINK formula but I am struggling to dynamically add this to the email address cell due to the double quotes an any examples all showing subject and body texts.
TIA
I need the email address to be shown as a clickable hyperlink to open a new email and to be entered via VBA code which works on the Worksheet_Change event
The new email doesn't need any subject or body text and just needs to be to the email address that is returned from the Access query
I can see that you can use the HYPERLINK formula but I am struggling to dynamically add this to the email address cell due to the double quotes an any examples all showing subject and body texts.
TIA
