Insert hyperlink to send email to VLOOKUP recipient

[Hills11]

I am looking to be able to insert a hyperlink to a column of words to email a set recipient based on a VLOOKUP i.e.

Column A:

ABC
ACB
BAC
BCA
BAC
ACB
ABC
BCA

EmailAddressSheet:

ABC | ABC@outlook.com
ACB | ACB@outlook.com
BAC | BAC@outlook.com
BCA | BCA@outlook.com

Does anyone know if any VBA coding can support this?

Thanks

 

[6StringJazzer]

It can be done with VBA but it can be done more easily with formulas. In column B use

=HYPERLINK(VLOOKUP(A1,EmailAddressSheet!A:B,2,FALSE))

and copy down

 

[Hills11]

See the issue I have is that I need the hyperlink to be on the values in the cells on column A, I already have data included within the next say 50 columns,

is there a way to insert this usung VBA onto the existing cell values?