Create Hyperlink and send via email

[tcheck]

We currently send an email to internal users that points to hyperlink address. We create an email, enter the symbol(ABC for example) and we then right click and point to the correct directory for the PDF document and the link is created so the user sees



ABC

in the email, clicks on it and the PDF is opened. I tried to create this in a query and export it to a TXT document and it works but it does not look as nice, I get something like this;

<a href="http://Mywebsite.net/rpts/ABC.pdf">CYBX</a>

How can I email the symbol with the link burried behind it but when clicked on (in an email) it goes to that link?

Thanks.

[June7]

This worked for me:

Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.To = "email address here"
.Subject = "Test"
.BodyFormat = olFormatRichText
.HTMLBody = "<a href='http://Mywebsite/ABC.pdf'>CYBX</a>"
'.Send
.Display
End With

[tcheck]

Thanks.

Does the .HTMLBody = "<a href='http://Mywebsite/ABC.pdf'>CYBX</a>" come out of the Query where as CYBX would be [Symbol] in the query?

[June7]

Sorry, I missed the point about exporting to a text document. In my testing, doesn't export as link, just simple text, not even clickable.

Don't understand, if user is browsing to file, why is a query involved? Why export to text file? Don't you want the link in the email body?

[tcheck]

Because there may be many each day, so there may be 5-15 different symbols for that day. The ABC would also come from the database so it should be

"<a href='http://Mywebsite/"& [Symbol] & ".pdf">[Symbol]</a>

[June7]

Need more concatenation, missing an apostrophe:

"<a href='http://Mywebsite/" & [Symbol] & ".pdf'>" & [Symbol] & "</a>"

Still not fully understanding behavior. Does user 'right click and point to the correct directory' and this is saved to table then code runs to get value from table? How is export to text file involved in this email process?

[tcheck]

I know the format is not exact since i left the office.

It would run automitcally after a new symbol(s) was entered into the database and the query would produce ablist for that day of symbols. And then a user would get an email with the symbol and the underlying link. It works now but does not look as nice.

[June7]

Does not look nice in a text file? Afraid can't help with that. As stated earlier, my test of export does not produce clickable link.

If you want to provide db for analysis, follow instructions at bottom of my post.