![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
Hi,
I have written one add-in which replaces [a-zA-z]#[0-9] or [a-zA-z]#[0-9]#[0-9] with the hyperlinks. It is working fine(attached portion of code). I found the two problems. 1. The hyperlink (in format of "http://mylink/Q/") is getting converted into clickable link if I use objSafeMail.Body instead of objSafeMail.RTFBody in my code but usage of objSafeMail.Body converts mail format to plain text. 2. If I use objSafeMail.RTFBody then hyperlink is becoming non-clickable. Could any one suggest me if in Option#1 (while using objSafeMail.Body) it is possible to persist email format as it is OR in Option#2 is it possible to make replaced hyperlink to clickable, Code: Private Sub objMailItem_Send(Cancel As Boolean) Const Link = "http://mylink/Q/" Const REQUEST_PATTERN = "([a-zA-Z]+)(\#[0-9]+){1,2}(?!\#)\b" Set oRE = CreateObject("VBScript.Regexp") With oRE .IgnoreCase = True .Global = True .MultiLine = True .Pattern = REQUEST_PATTERN End With objMailItem.BodyFormat = olFormatHTML objMailItem.Save Dim objSafeMail As Redemption.SafeMailItem Set objSafeMail = CreateObject("Redemption.SafeMailItem") objSafeMail.Item = objMailItem Set oMatches = oRE.Execute(objSafeMail.Body) objSafeMail.RTFBody = oRE.Replace(objSafeMail.RTFBody, Link & "$1/$&") objSafeMail.Save For Each omatch In oMatches objSafeMail.RTFBody = Replace(objSafeMail.RTFBody, "/" & omatch.SubMatches(0) & "#", "/") objSafeMail.Save Next End Sub Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sending a clickable email | RoyT | Outlook and VBA | 2 | March 18th 09 09:15 PM |
Blocked links still clickable | Mark Hall | Outlook - General Queries | 0 | February 22nd 07 02:30 PM |
clickable links | Debbie | Outlook Express | 16 | October 22nd 06 10:51 PM |
Problem with Outlook hyperlinks (html format - sorry..) | Brian Tillman | Outlook - General Queries | 2 | May 17th 06 02:54 AM |
URL's not clickable in email | Bob Day | Outlook - General Queries | 2 | May 13th 06 05:06 PM |