Post reply

SENDING EMAILS USING MULTIPLE MAPI PROFILES

  • November 13, 2003 at 4:09 am

    #106819

    Hi,

    I have Outlook 2000 installed on my IIS / SQL server and have two Outlook profiles configured to connect to seperate Exchange accounts.

    I would like to send emails depending on the message from either of the two profiles. Except it always sends the message from the default profile account 'Profile 1'!

    How do I select a different profile name prior to sending the message ?

    e.g.

    EXEC master.dbo.xp_startmail 'Profile 2'

    EXEC master.dbo.xp_sendmail

    @receipients = 'Mike',

    @subject = 'test',

    @message = 'message'

    This sends the email from the default profile 'Profile 1' !!!!!!!

    Also, is it possible to send an email in HTHL format rather than plain text ?

    Cheers.

    Mike

  • November 13, 2003 at 7:31 am

    #481842

    1. You have to specify a password and make sure that the SQL Server account has access to that other Profile!

    2. Sendmail does NOT provides HTML capabilities 🙁

    HTH


    * Noel

  • November 13, 2003 at 7:37 am

    #481848

    Thanks for that.

    Our IIS server is logged in as Administrator and both Exchange profiles can be access by this user.

    Do you mean I should start the xp_startmail with an NT user name and password rather than a profile name ?

    EXEC master.dbo.xp_startmail 'NT User Name', 'Password'

    Cheers.

    Mike

  • November 14, 2003 at 9:08 am

    #482080

    1.The IIS account is not important for that, is the SQL Server Service Account the one that has to have the permissions

    2. The procedure is like this

    exec xp_stopmail -- Stop the session if Running

    exec xp_startmail 'PROFILE NAME', 'password for user'

    exec xp_sendmail @recipients ='account@domain.com', @subject ='test'


    * Noel

  • November 14, 2003 at 9:27 am

    #482082

    Hi,

    It works !!!

    I think the key to this one is you stopped the mail service before specificing a new profile as it also works now without sending a password.

    Thanks once again.

    Mike

  • November 14, 2003 at 10:53 am

    #482100

    Because you are using Exchange Mail and NOT internet mail you are authenticating with NT Account only and that's why you don't require password.

    I am glad I could help


    * Noel

Viewing 6 posts - 1 through 5 (of 5 total)

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