How to create a hyperlink

[ruthcali]

I am using Access 97 and Outlook 98.

I have a command button on a form that opens Outlook and begins an email message. I am trying to put a working hyperlink in the body of that email. I am also trying to turn other text red if it meets a criteria:

DoCmd.SendObject , , , , , , , "Go to:

http://www.test.com"

& vbcrlf & IIf(txtUrgent = 1, "this is urgent", "not urgent&quot.

When Outlook opens, the test.com isn't a working hyperlink, it's just plain text.

And how do i make the words 'this is urgent' turn red?

Thanks,
Ruth

 

[mp9]

Not sure why this hyperlink doesn't work correctly, it does for me. As an aside, you might want to try using the fctnOutlook available at

http://www22.brinkster.com/accessory/modules/005.shtml

instead, for the following reasons:

- Mails will be sent in your preferred Outlook format (e.g. Rich Text or HTML) rather than plain text, which may address the hyperlink problem.
- You can set message priority flags on the e-mail, which may help to indicate when your mail is urgent.
- It'll make migrating to Access 2000 easier, as DoCmd.SendObject is unreliable in Access 2000.

HTH.

http://www22.brinkster.com/accessory/

 

[ruthcali]

Hi,
Thanks for writing. You're right--it depends on my mail format setting in Outlook. (Tools, Options, Mail Format tab, Message Format drop down box).

I had mine set on Microsoft Word and i couldn't get a hyperlink, i just got text. In order to get a hyperlink, i had to put my mouse at the end of the link and press the Enter key. Pressing the Enter key at the end of the link made the text turn blue and into a true hyperlink.

But when I changed my Outlook Message Format to HTML or Microsoft Outlook Rich Text or Plain Text, then it becomes a real hyperlink!

This holds true using docmd.sendObject or fctnOutlook.

But, I didn't see in your code how to force Outlook to open using HTML or Rich Text or Plain Text. Is there a way to do that? (is there a way to force Outlook to open using HTML or Rich Text or Plain Text using docmd.sendObject as well?)

Thanks,
ruth

 

[mp9]

Hi Ruth,

You're right, there's no way in my code to force Outlook to use a certain format. As far as I'm aware there's no way using DoCmd.SendObject either.

I'll investigate a modification to my code and post any findings here.

Cheers,
Martin

http://www22.brinkster.com/accessory/