Post reply

HTML format in sp_send_dbmail

  • October 12, 2010 at 2:33 pm

    #145640

    Hi,

    i formated sp_send_dbmail in such a way to send email in HTML with a table it sends the email properly but while forwarding the email the format i have designed is creatd with one more row in between my header and data.

    i will send emails with only one data. Kindly help me to retain the format while forwarding the mails also.

    Thanks in advance.

    Regards
    Durai Nagarajan

  • October 12, 2010 at 3:34 pm

    #1235898

    a forwarded email is beyond the control of the SQL server and sp_send_mail;

    the client application which forwards the mail may add lines, headers, footers, indent everything in the email and more.

    one client application may fiddle with it as you describe (Outlook?) but another may treat it differently(gMail,Thunderbird,yahoo, etc)

    there is nothing you can do to the email once it is received, and thus, can be forwarded.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 13, 2010 at 7:40 am

    #1236194

    Hi,

    thanks for your reply,

    i am using outlook 2003 only. but i thought there is a solution to it.

    Regards
    Durai Nagarajan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply