VBA hyperlinks in Excel

User142523653

New Member
Joined
Oct 31, 2019
Messages
1
Currently in the middle of an assignment where you have send an excel file as a hyperlink rather than an attachment using VBA, Is there any possible way to do this as at the current moment I am only able to send the location of a link as regular text rather than a hyperlink. Any help would be great appreciated.
Many thanks.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

daverunt

Well-known Member
Joined
Jul 9, 2009
Messages
1,800
Office Version
2013
Platform
Windows
I assume you mean via Outlook?
If so you send it as an HTML mail using .HTMLBody instead of .Body
 

Watch MrExcel Video

Forum statistics

Threads
1,099,510
Messages
5,469,042
Members
406,631
Latest member
hotspot1972

This Week's Hot Topics

Top