Post reply

xp-sendmail to send HTML text

  • June 19, 2002 at 10:51 am

    #78967

    Want to use xp_sendmail to write HTML email reports. Is there a way to indicate in the email header that the MIME type is HTML so the email clients will format the reports appropriately or am I going to have to go outside the SP API and look at something like CDO.

  • June 19, 2002 at 5:16 pm

    #431179

    Sorry no paramter to set the mime type in xp_sendmail.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • June 21, 2002 at 8:33 am

    #431357

    James - thanks. I went out to some more newsgroups and got the same answer from looking at people with the same problem and even noticed somebody on this newsgroup had posted the same problem previously. Since I have Outlook loaded on the server and don't want to create a SMTP server I am getting around the email issue by using OLE Automation with Outlook to send nicely formatted reports. Intend to call the exe I've built thru a SQL Server. A pity - I was really hoping to do absolutely everything in Transact SQL.

  • June 21, 2002 at 10:22 am

    #431371

    You can in T-SQL, but it's an ugly mail message you have to build. I too wish MS had included this.

    Send it to sqlwish@microsoft.com

    Steve Jones

    steve@dkranch.net

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

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