Excel VBA Macro: Send Email with Hyperlink (Step-by-Step Tutorial)

Excel VBA Macro: Send Email with Hyperlink (Step-by-Step Tutorial). In this video, we create a macro that automatically sends an email with a hyperlink in Outlook. We use two examples for the hyperlink: the first example uses a hyperlink to access a file on your computer, the second example uses a hyperlink to access a website. For the first example, we go over how to easily find the correct file path by adding Document Location to the Quick Access Toolbar in Excel. We use HTML to compose the body of email and go over how to change the font size and font type. We also go over how to use the current date in the subject line, and how to change the format of the date.

#ExcelVBA #ExcelMacro

[tehsuantee]

thanks, exactly what i need, appreciated

[Sebastian.]

Awesome, thank you so much. I really appreciate your video

[LookinReasonsLaugh]

Thanks, Greg-- how do you make this dynamic though? I have a big long dynamic formula for the body text in one cell, which I can't use with =HYPERLINK, so I'm looking to VBA now... Don't know how to do cell references in there. Otherwise, it looks like I could just follow this tutorial exactly and be ok...! :)

[thefjrl]

Is there a possibility that you can add an hyperlink if the email is in teams outlook meeting?

[damiendesmortreux]

Great tutorial, I'm actually trying to hyperlink a fedex tracking number in the body of an email but I can't figure out how to get it work by somehow concatenating the fedex website address with the tracking number that is in a cell in excel. Any idea?

[irinkhan]

When my email id is wrong (i.e, not found in mail address book), the macro stops running. What can be done to prevent thia as this prevents from sending my others mails to users in the same column??

[cindycollins]

I get a runcode error: 429 Active-X component can't create Set OutApp = How must I fix this

[jadzeinaldeen]

Dear Greg, I have an error that the recipient cannot open the mail link

[hamzaguich]

please any idea about space in path it doesnt work please ??? it stop the link just before the space?

[itguy]

Dear Sir, Let say you asking for some update on activity performed by an team in mail is way too far down in mail trail (lets, three months before in January ), and now in April you are asking for an update on that activity in same mail, and but mail is too long and context of message body you need to point out in reply is way down which will require so much scrolling down, so instead of that scrolling way too down, can I create link in reply mail, which once click can directly take receiver to required context of message body? Thanks.

[anthonydimeo]

Hi. I tried this but my issue is the email shows the actual name of the path after the A HREF underlined in the email. How come the path name is in the email. I just wanted the word here to be underlined??? Please help.

[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?

[rakshitharamesh]

The path of my file name has spaces so the hyperlinks in the email body won't work. Any idea?

[dennisprada]

The path of my file name has spaces so the hyperlinks in the email body won't work. Any idea?