Image 1 of 8
Joshua Hoskins wrote about xp_SMTPSendMail80’s ability to send mail directly from SQL Server to an SMTP server in a The Right Tool for the Job? blog post.
Sending a basic e-mail
Here the basic syntax used for sending an e-mail with xp_SMTPSendMail80 is shown.
Basic e-mail in Outlook
This image shows the format of a basic e-mail as seen in Outlook 2003.
Embedding a query in e-mail
This screenshots shows the format for embedding a query within an e-mail.
Query results e-mail
This image shows the receipt of the e-mail with the embedded query.
Sending an HTML e-mail
This picture shows the syntax of sending an HTML-formatted e-mail with an embedded query.
Receiving an HTML e-mail
This screenshot shows the receipt of the HTML-formatted e-mail with the query embedded.
Sending an attachment to multiple recipients
This picture shows the syntax to use when sending an attachment and sending to multiple recipients.
Receiving an attachment e-mail
This image shows an e-mail received from xp_SMTPSendMail80 with an attachment.