Adding a Link to another spreadsheet in email body using VBA

Good morning,

I have VBA coding that sends an email to a specific person depending on what name is entered into a form.
I want to be able to add a link within the email that will take the recipient to a specific spreadsheet, the link is different for each person,. The link to be placed in the text body comes from cell AM22.

I have the following code, it sends everything that i need it to apart from a workable link, currently it is just populating the text from AM22 (not showing as a link)

Please Login or Register  to view this content.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer

Very new to VBA and any guidance would be greatly appreciated.

Scott

To include a link in an email, you have to use HTMLbody instead of Body, and write the content in HTML. You did not give us enough information to know where the file is to be able to link to it.

An HTML link cannot link to a specific worksheet or cell in an Excel file. You can do this internal to an Excel file with a hyperlink in a cell, but not from a link in an email. The best you can do is link to the file and Excel will open it.

There is the other question of where the file is stored and whether an email can even link to it at all.

I am reading your post again and I may have misunderstood. You don't want to link to cell AM22; the content of cell AM22 gives you the link. Here is how I would write this, also splitting up the line for readability:

Please Login or Register  to view this content.

Impossible to test without your file.