Professional Web Applications Themes

email, profiles and from properties... - Microsoft SQL / MS SQL Server

I need to be able to send email from sql, but have the mail return address be from different 'mailboxes'. Do I need to configure different profiles for this, or am I missing a parameter in xp_sendmail or somewhere else? Thank you in advance. Robert Taylor *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default email, profiles and from properties...

    I need to be able to send email from sql, but have the mail return
    address be from different 'mailboxes'. Do I need to configure different
    profiles for this, or am I missing a parameter in xp_sendmail or
    somewhere else?

    Thank you in advance.

    Robert Taylor


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Robert Guest

  2. #2

    Default Re: email, profiles and from properties...

    OJ,

    Thanks, but xp_smtp_sendmail requires that relaying be enabled on a mail
    server (not a good thing) in order to do what I want to do.

    Thanks for you time.

    Robert



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Robert Guest

  3. #3

    Default Re: email, profiles and from properties...

    Robert,

    Unfortunately, xp_sendmail uses the profile defined for SQL Mail which uses
    the acct used for SQL Server service. That means you can only have one
    profile attached. This sounds like a good sqlwish. You might want to send MS
    com

    --
    -oj
    RAC v2.2 & QALite!
    http://www.rac4sql.net



    "Robert Taylor" <com> wrote in message
    news:Ob%phx.gbl... 


    oj Guest

  4. #4

    Default Re: email, profiles and from properties...

    OJ,

    Thanks. I think I will do that. You should at least be able to specify
    the Reply to fields value.

    Robert


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Robert Guest

Similar Threads

  1. ViewState properties and mapped properties don't work well togethe
    By Christophe Peillet in forum ASP.NET Building Controls
    Replies: 2
    Last Post: January 21st, 07:35 PM
  2. Making Custom Control Properties Visible in Visual Studio's Properties Palette
    By Nathan Sokalski in forum ASP.NET Building Controls
    Replies: 0
    Last Post: October 17th, 02:05 AM
  3. Email button does not open to preferred email client in Windows 98SE
    By Catherine_Arceneaux@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 6
    Last Post: May 20th, 11:18 PM
  4. Illustrator properties vs FreeHand properties
    By Ian Kelleigh in forum Macromedia Freehand
    Replies: 1
    Last Post: December 31st, 12:18 PM
  5. properties not showing in properties window at design time
    By Peter in forum ASP.NET Building Controls
    Replies: 2
    Last Post: December 10th, 03:30 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139