Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

By Bill Detwiler February 27, 2006, 3:05 AM PST billdetwiler

Image
1
of 8

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.

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

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.

By Bill Detwiler

Bill Detwiler is the Editor for Technical Content and Ecosystem at Celonis. He is the former Editor in Chief of TechRepublic and previous host of TechRepublic's Dynamic Developer podcast and Cracking Open, CNET and TechRepublic's popular online show.

Account Information

Contact Bill Detwiler

Your message has been sent
|
See all of Bill's content

Internet of Things devices serve a number of useful applications, such as environmental, asset or inventory monitoring/control, security functions, fitness devices and smartwatches. There is an array of IoT functions for both consumer and business purposes, but determining the total cost of ownership and the return on your enterprise investment in a widespread or large-scale ...

No matter where in the world an enterprise operates, politics is going to play a major role in the lives of its employees. Depending on the country and the current political situation, it’s possible for affiliations, candidates and political parties to become a driving passion in your workforce. While an actively engaged workforce taking interest ...

The importance of diversity and inclusion in any given organization cannot be overstated. It establishes a level playing field, brings together people with different backgrounds, perspectives, traditions and ideas and enriches company culture by ensuring fairness and tolerance. This helps build a more effective and collaborative workforce which enables the business to run in a ...