Convert Email body into HTML

[nicki]

Hello,

I have VBA code that reads from a table and sends Emails to the recipient by attaching a report.
The body of the email says something like:

StrBody = "Hello etc."

The requirement is to add a HYPERLINK to the body of the email so it says something like:

StrBody = "Hello click here to see something"

The "Here" is an actual hyperlink that takes them to a sharepoint site.



I can do it by displaying the actual hyperlink and the recipient will see the url (ugly solution) but I really want the word to say Here.

Access VBA does not recognize the html brackets like <a href = "https:// etc".

How do I do it ?

[Welshgasman]

You would construct the html just as it would be on a html page.
You would however need to use HTMLBody.

[nicki]

I am not savvy in HTML, I just now that I have to do this to create a Hyperlink:

<a href="url">Click here </a>

How do I force VBA to understand that this is HTML code ? I obviously do not have the option to create a variable and declare it as HTML.

Thanks

[Welshgasman]

Outlook has .HtmlBody where you can build text in html format. Google to see how a link is constructed and copy that logic.
This member was trying to construct html and a useful link is in that thread.
https://www.accessforums.net/showthr...highlight=Html

[nicki]

That worked !
thank you