Outlook Outlook 2010 Email Body Messages - Auto Hyperlink

[uzziwozzi]

Hi there

Is there a VBA expert who can help me with the following request?

I have a database that has hyperlinks to cases already formed

What we would like is, for example, if we wanted these cases to be auto hyperlinked to the databases from the body of an email?

E.G sample body of text
--------------
Hi there - your case is CRS1111
-------------
This CRS is then hyperlinked to http://database/csrs/11111

So the identifier is the keyword CRS and anything after is the reference or variable that it needs for the hyperlink

Is this possible in VBA?

 

[alow]

I don't know about doing it automatically with VBA, but you could highlight the text you want to hyperlink, press Ctrl+K and put the text in for the hyperlink that you want.

 

[uzziwozzi]

Hi there - thanks for the reply. The idea is to have this automated as we do know we can hyperlink manually.

I was thinking on the lines of some sort of intellisense where as you type the hyperlinks are formed if you type a set of keywords, e.g CSR..