Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Voorhees, NJ
    Posts
    1

    Question Unanswered: xp_sendmail on MS SQL Server

    I've built a procedure to execute the xp_sendmail process for a set of records using a cursor. I have been able to populate all the neccessary mail elements with the neccessary text and field trade-in's. I am however not able to change the FROM field in the header of the e-mail. It simply spits out the name of the database followed by a "- SQL Server". Does anyone know how to go about changing the FROM field?

    ** I'm working in MS SQL Enterprise Manager **

    - c0rk

    http://c0rk.blogs.com

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    All the settings are in BOL - I'd suggest you code the email using xp_sendmail then you can customise it in the cursor.

    Cheers

    SG

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •