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.