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

[@ultragucci]

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

[@greggowaffles]

No prob! So glad to hear that!!

[@anastasiiamorozova3417]

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?

[@jevarajanganasan9708]

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

[@quochungtran8127]

Great Video. Thank you very much!!!

[@greggowaffles]

No problem! Thanks!!

[@Asc4ri]

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

[@greggowaffles]

thanks! yup! you can just add the RangetoHTML function in the body of your email and specify which range you want to use for your table. apologies for the late reply!

[@eliascamacho]

Amazing

[@greggowaffles]

Thank you!

[@BHJP88]

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?

[@miggi4665]

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.

[@greggowaffles]

Hey can you give me an example of what you're talking about?

[@PixelVogue]

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

[@hamzaguich2515]

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, You can access to the file from " & "here"
the link will be in this case : C:\Users\Desktop\fs
any idea?

[@He787878787787]

Replace the spaces with "%20"

[@MrBumbum2812]

Nice

[@greggowaffles]

Thanks!