Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

xp_SMTPSendMail80

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.