Adding an Excel Hyperlink in Outlook with an Excel Macro
Posted on 2011-02-24
Hi Guys, I am sending a Excel piece of work to my manager which he must approve via e-mail.
He wants a hyperlink to the Excel path in his e-mail so he can see it straight away. I have this code which sends him the e-mail from an Excel button with Voting Buttons but only text appears not a Hyperlink. Any ideas how its done?
.To = "firstname.lastname@example.org;"
.VotingOptions = "Approve;Reject" 'you can include what you want in fact
.CC = ""
.BCC = ""
.Subject = "FITR Dailies - "
.Application.ActiveInspector.CurrentItem.HTMLBody = "G:\Restricted\UKMFG-TS-AM-EUC03\TRES\FITR - P11 Feb'11\FITR Oracle Dailies Feb'11.xlsm"
' On Error GoTo 0