MS Access VBA / RTF/ Email link

Check function slike URLDecode and URLEncode
http://msdn.microsoft.com/en-us/library/zttxte6w.aspx

There are implemenation for VBA at:
http://p2p.wrox.com/excel-vba/79712-encoding-url-utf-8-vba.html

or maybe have a look at:
http://www.freevbcode.com/ShowCode.asp?ID=5137

Regards
Friedrich

If you're using the HTMLBody, which it seems you are, then the link should be represented as a Link. You can include standard HTML tags in the HTML body, and they'll be represented as such.

However, it doesn't look like you're after a link, but rather you want a "link" in your email's body to fire off a program on the desktop, or something of that nature? If so, that's the very definition of spam/malware and wouldn't be allowed (even though I'm sure you're not intending this to be spam/malware).

Thanks LSM - I'm trying to have an email (generated by the DB) send to the user, including a link in the same email to allow the user to open the DB to a specific record.

IE, if I have the user click on a shortcut on their desktop with it's target set as:

"O:\Mobile Services\Servicecenter\IcMT\ActionLog\ICMT Daily Action Log.accdb" /cmd ActionID=2

it works - opening the correct (ActionID 2) record I want.

However, I can't seem to embed this in an email link allowing the user (who may not have access open) to go directly to the record referenced in the email FROM the email itself.

IE, imagine you place an order with an online retailer. They send you an email saying "click here to check the shipping status of your order" - you click it, and it takes you directly to your exact order, rather than just to their website, where you have to sign in, click orders, click history etc etc.

Hope that makes sense!

Thanks for taking the time to think about it

Ross

This syntax works fine for me:

       .HTMLBody = "This is a clickable hyperlink: " & "<a href=" & "www.CNN.com" & ">" & "Link To CNN.COM" & "</a>"


See this link as well:
https://www.experts-exchange.com/questions/26606114/Hyperlink-field-in-the-message-of-email-in-access-form.html

JeffCoachman

Right, I understand what you're trying to do - it's just not really possible to do this directly, and there are many problems that can cause this to fail.

YOu might review this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1639722

The post about using the autoexec macro might be something you can adapt. Basically, the autoexec macro looks for a commandline that's being passed in, and can process the arguments in that comment line argument.

This works (well, it opens the database, just not passing the command line string obviously)

strbodyMsg = strbodyMsg + ("<A HREF='file:///O:\MOBILE~1\SERVIC~3\IcMT\ACTION~1\ICMTDA~2.ACC'>CLICK HERE!</A>")

But this doesn't:

strbodyMsg = strbodyMsg + ("<A HREF='file:///O:\MOBILE~1\SERVIC~3\IcMT\ACTION~1\ICMTDA~2.ACC /cmd ActionID=2 '>CLICK HERE!</A>")

Replacing spaces with %20 doesn't seem to help either.

What do you mean by "this doesn't"? Does it do nothing, or does it open Access but not the form, etc etc. Using the /cmd action requires more work on your end ...

Thanks LSM - I'm already doing just that (the command line checking in autoexec). The problem I'm having is embedding that command line switch in the link the DB emails OUT - ie, if I send a link in the email to open the DB it works (but sans command line switch). If I edit the link it sends out to have /cmd whatever on the end, it fails to open - outlook doesn't like it.

...produces this in the email body
(fully "clickable" and functional Hyperlink)
untitled.JPG

boaq2000 - thanks for the input but getting links in html email is fine - I need to add a commandline switch to the link - that seems to fail.

   Untitled.png

Sorry folks, I misunderstood the Question...

FWIW: I have never had good luck opening a databases from a hyperlink and have it "do" anything other than simply open the db...

RossDagley1, what is your ultimate goal here?

...perhaps there is a more efficient approach than using a Hyperlink?
For example, collecting Access data via email:
http://www.youtube.com/watch?v=RXeQeBOPOh8
http://office.microsoft.com/en-us/access-help/collect-data-by-using-e-mail-messages-HA010015427.aspx

I'm developing a DB to handle incidents that are raised. The incident is created, and when an update is made to the specific incident by someone, the person the incident is assigned to receives an email (as above screenshot) showing the update. If they want to respond, they need to open the DB, find the record, then update it.

Of course, this works fine. However, I've been asked to add a link (of whatever type works!) in the body of the email so the user can just click on the link and be taken to that specific record.

Using the /cmd switch and some work in a function I've created I can monitor the command line given to access as it opens (IE, as I posted in one of the first posts in this thread - a desktop shortcut with "database.mdb /cmd ActionID=2" works just dandy). However, I can't seem to figure out how to get this working as a link the user can click on from the email itself.

I hope thats clear - thank you all for your assistance thus far :)

Ross

<FWIW: I have never had good luck opening a databases from a hyperlink and have it "do" anything other than simply open the db...>

Me either, and I've tried many different ways. I don't think there is a reliable way to open Access (or any other program) on a remote machine using an emailed message.

That said:

Your trouble is with the /cmd switch? Can you post an example of the email HTML body that is sent out (i.e. the EXACT text that is in your strHTMLbody string) as well as the Source of that HTML body AFTER it's sent out?

What I'm asking for cannot be done apparently.