I am trying to use xp_sendmail to send query results (Outlook 2000 and SQL 2000). Executing the sp takes a long time - about 3 minutes before I finally receive the Sent Mail message but the recipient never receives the message.
Checking the Outllok client, I find the email in the INBOX. Opening the email has the Send Button available. Clicking on the Send button will go ahead and send the email.
I have tested the following:
• I can send email to and from the mailbox I am using (using the client)
• I have tested sending email from SQL mail – other than the delay it works
• SQLServices /SQL Agent services are using the domain account – same as the Outlook client. All 3 are using the same account.