How to send email to Lotus Notes using Excel with link of the Excel file inside the email?

Dear All,

Am still learning Excel Macro programming. Have manage to send email using Excel Macro to Lotus Notes but not sure how to send the email with the Excel link attach in Lotus Notes so that when people read the email in Lotus Notes can click a link to open up the Excel file straight away instead of search the excel file through the folders.

Am using below script to send email, can advise me on the script on how to send the email with the link of the Excel file too? Urgently need help.

Please Login or Register  to view this content.

Thank you.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(Because you are new to the forum, I have added them for you today. Please read all Forum Rules and comply in the future.)