xp_sendmail specify sender:

I have a question regarding xp_sendmail in sql server 2000.

SQL Mail is using an Outlook profile called 'SQLMail',
which I have configured with a mailbox called 'SQLMail'.
The sa_sql-account has permissions to the mailbox.
Everything works fine.

Here comes the problem.
All the mails being sent comes from the same sender (SQLMail).
I would like to specify the sender.

Ex I have a table with message, subject, attachments, recipients and sender.
Sender is a valid exchange mailbox. sa_sql has permissions to all mailboxes on the exchange server.

In Outlook I can specify the sender in a From field. I want to do the same from sql server.
LVL 3
olaAsked:
Who is Participating?
 
curtis591Connect With a Mentor Commented:
I know of no way to do it with xp_sendmail but you might be able to use OLE Automation with Outlook from inside a SQL stored procedure to send your message.  
0
 
olaAuthor Commented:
I found an article on this.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q312839

With this solution mails is sent through smtp.

I think I need a mapi solution. The mails sent should
be stored in 'Sent Items' in the senders Mailbox.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.