NewItemAlert Modification for outlook path link

[beowulfs]

I've got the NewItemAlert working, but i don't like having to click a
web browser link and then insert my uysername and password. i'd rather
have it put in an outlook style link, outlook:\\public folders\All
Public Folders\Newsgroups. that way, you click on it and it brings up a
new outlook window in that folder. I'd also like the subject line to
list not only the subject of the newly posted message but the folder it
was posted to as well (i'm using it on 5 different folders). i've been
running through the script and msdn all day, and i'm burned out. i
just don't know enough vb and cdo to figure it out. could someone
help? thanks.

[beowulfs]

solved it myself:

added this:

Dim strOutlookable ' As String added by Troy
Dim strOutlookableL ' As String added by Troy
Dim strOutlookableR ' As String added by Troy
Dim strOutlookableT ' As String added by Troy
Dim intOutlookcount ' As Integer added by Troy
Dim intOutlookcountR ' As Integer added by Troy

' Covert ExOLEDB item URL into an Outlook usable url
intOutlookcount = Len(bstrURLItem)
strOutlookableR = Right(bstrURLItem, intOutlookcount-39)
strOutlookableL = Left(strOutlookableR, 14)
strOutlookableR = Right(strOutlookableR, Len(strOutlookableR)-15)
intOutlookcountR = InstrRev(strOutlookableR, "/", -1, 1)
strOutlookableR = Left(strOutlookableR, intOutlookcountR-1)
strOutlookable = "outlook://" & strOutlookableL & "/All Public
Folders/" & strOutlookableR
strOutlookableT = Replace(strOutlookable, "/", "\")
strOutlookable = Replace(strOutlookable, " ", "%20")

strHTMLBody = strHTMLBody & "
Click here to see NEW the item
submitted to <a href =" & strOutlookable & ">" & strOutlookableT &
"</a>.

"

beowulfs wrote:

I've got the NewItemAlert working, but i don't like having to click a
web browser link and then insert my uysername and password. i'd
rather
have it put in an outlook style link, outlook:\\public folders\All
Public Folders\Newsgroups. that way, you click on it and it brings up
a
new outlook window in that folder. I'd also like the subject line to
list not only the subject of the newly posted message but the folder
it
was posted to as well (i'm using it on 5 different folders). i've
been
running through the script and msdn all day, and i'm burned out. i
just don't know enough vb and cdo to figure it out. could someone
help? thanks.