Hyper Links

Posted on 2011-10-13
Last Modified: 2013-11-30
I have smtp-mail creating email messages to clients with an embedded hyperlink from a stored procedure in SQLServer 2000.

When the mail is formatted, I send it to the client and Bcc myself.  I have been having issues with a number of the clients unable to connect to the url in the link due to the fact that their hyperlink has extra erroneous characters embedded, yet if I look at the copy of the email that I received everything is fine and I can click the link and get to the correct URL???

Anyone with a pointy hat with moons and stars on it that can give me any explanation?
Question by:Jeff_Kingston
    LVL 1

    Expert Comment

    maybe they are receiving only text emails, and HTML is turned off.

    It can be as simple as that.
    LVL 1

    Expert Comment

    Make sure that you leave spaces around the link, and leave the link in plain text so that readers can click on the link without issue. Sometimes, surrounding characters may interfere with the link. If you are sending an HTML email, try using a text email (a user's email client might not support HTML email).
    LVL 38

    Expert Comment

    Jeff, could you possibly get one of the affected recipients to forward the email back to you while retaining the original formatting so that you can view the source and inspect the portion of code that contains the non-working hyperlink with "erroneous characters"?

    Any common denominator between clients who don't have a functional link and those who do (eg. ones that don't work are opened in Outlook and those that work are opened in another client, or perhaps opearating system differences)?

    Author Comment

    I send the email and bcc myself.  I can open the link some of the time but not all of the time there are erroneous spaces and other characters In the URL when it does not work.  I have had them forward the email  to me and the link is truly bad, yet most that I receive as bcc'd are fine.  There has to be some truly strange issue with smtpxpmaIL  This issue has caused some very ill will to us and I'm going to have to find a workaround or another piece of mailing software
    LVL 11

    Accepted Solution

    Probably the trouble is not the mailing software.

    Try avoid

    Links with spaces
    Links with special caracters
    Links in HTML (such <a href="...)

    Instead, always use the alternative body part that have a copy of message in plain text.

    Some e-mail clients cannot work with messages that have lines with more than 80 chars, but I guess that your mailing software do the right job.

    To use spaces or special chars you need to do a encode on it (i.e [space] will be %20).

    Try things like
    put the link on body like a simple text
    create links without spaces and special chars.

    Try to know what kind of e-mail client have trouble to work with these links.

    Author Closing Comment

    We have added the option of displaying the link itself and giving the customer that as an option if the smtpmail software decides to corrupt the link.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    The viewer will learn how to user default arguments when defining functions. This method of defining functions will be contrasted with the non-default-argument of defining functions.
    HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now