This question is aimed at acperkins, but any and all can answer :o)

I have been experimenting with xp_smtp_sendmail that you mentioned in another thread on our development server.

One thing I cannot get the way I want is as follows:

When I send a text message with:


it automatically turns into a link in my email client (currently experimenting with Outlook 2003)

When I send an html formatted message with the same exact text it is not linkified - is that a word? ;o)

I need to ensure that whether the email is sent via text or html (I have a variable set as a switch which relate to the user preference) - that the link is a real link that can be clicked.

Is there something I can do to make this happen besides adding in <a> tag coding?


PS I won't be able to respond to comments until Monday.
LVL 35
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anthony PerkinsCommented:
In a sense this has nothing to do specifically with xp_smtp_sendmail and more to do with how Outlook interprets hyperlinks.  The way that I resolved it was by precisely the way you were trying to avoid. i.e. Sending using HTML and using anchors.

Perhaps someone in the Outlook Topic Area has some workaround..

I trust I understood your question correctly.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mrichmonAuthor Commented:
Well I will end up doing that if all else fails, but as we are trying to dynamically determine whether to send an HTML message or TEXT message it makes it more difficult.

Encoding simple things is easy (such as bolding text), but things like a hyperlink requre more complex logic - that we were hoping to avoid.

We are actually looking at an alternatinve of creating an executable in .NET and scheduling it through SQL server so that we have more freedom and ease of coding in complex logic with sending of email messages.
mrichmonAuthor Commented:
Well haven't found anything else as a solution....
Anthony PerkinsCommented:
Ah, yes, the infamous "C" grade.  Perhaps next time, if you do not like the answer, you can ask that the question be deleted.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.