Send Email with Dynamic Hyperlink (Variable Based on Cell Value) | Excel VBA Macro

Excel VBA Macro: Send Email with Dynamic Hyperlink (Based on Cell Value). In this video we go over how to send an email that contains a hyperlink based on cells that we concatenate. We use a variable (hyperlink) that changes based on the the selection chosen from a drop-down.

#ExcelVBA #ExcelMacro

[ultragucci]

This video has helped me solve a problem I have been having for weeks.
Thank you.👍

[anastasiiamorozova]

Hi Greg, thanks for video! is it possible to send the emails to all 4 people at once without choosing them one by one from the dropdown menu?

[Ascri]

Great video, thank you! Is there any way to combine this hyperlink when sending an email as a table also per your other tutorials?

[PixelVogue]

Nice one mate, can this work for web based email e.g. Outlook or Gmail?

[BHJP]

Hi Greg, I have all the steps working, but they hyperlink wont open in the email, so when i click 'here' it wont open the link address? Any ideas?

[jevarajanganasan]

it returns true on the body of the email.. How to solve ya ? Thanks in advance.

[miggi]

Hi Greg, is it possible to reference the first name only for the recipient in VBA instead of the full name? I used the one you have in your previous video with the format name = ros.Cells (2, 5).Text but this gets the full name from excel and bot the first name.

[hamzaguich]

please i need help 
it doesnt work when the link have spaces in it
for ex file path 
MsgBox "C:\Users\Desktop\fs caché\Fusion fichier\TENDERING.xlsm"
xstrbody = "Request for an approval, <br> You can access to the file from " & "<a href= " & link & ">here</a>"
the link will be in this case : C:\Users\Desktop\fs
any idea?