I'm using CDO to handle outbound mail from access.
I've set objMessage.HTMLBody
Everything works just how I'd like (IE i receive email, with formatting), but I don't know how to get a link embedded in my body. The body content srtbodyMsg is coming from a lookup table (memo field with rich text format).
Ideally I'd like a nice link like:
">Somewhere</A> but obviously putting that in with the rest of my body just gives me the literal text as is, with punctuation as is etc.
I made slight progress using:
strbodyMsg = strbodyMsg + ("file://O:\MOBILE~1\SERVIC~3\IcMT\ACTION~1\ICMTDA~2.ACC" + " /cmd" + " ActionID=2")
but then everything after (and including) the /cmd isn't part of the link - I'm guessing because of the space (I got around the space issues using 8.3 format for the main link to the DB).