VBA equivalent of Excel HYPERLINK function

[DP13]

Hi,
I'm looking for the VBA equivalent of the Excel HYPERLINK function.
I need to attach a pdf to an email using the default email client (including the recipient's email and subject line) and allow the user to add information before sending the email.
This will allow user intervention but importantly, also not impact the email client's security.

Any guidance and help is appreciated.
Thanks

[MrChulo]

Hello DP13,

Do you want a hyperlink or attach?

For attaching documents:

Please Login or Register  to view this content.

Source: https://wellsr.com/vba/2018/excel/ex...th-attachment/

For creating a hyperlink, you would have to make sure that your email is in HTML format and then create the a HTML link.

Please Login or Register  to view this content.

Source: https://www.w3schools.com/html/html_links.asp

[DP13]

Hi MrChulo,

Thanks for your advice.
I need to attach a pdf to a new email in the default mail client (not always Outlook) and then display it - not auto send.

Most of the users have gmail and I don't want to get their passwords and the settings to enable the usual VBA methods.

The Excel HYPERLINK does what I want but I need to attach a pdf, not the current worksheet.
Is there a way to emulate it with VBA and then change the addition of the current worksheet to adding a pdf in a folder?

Regards