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

The purpose of the Incident Reporting and Response Procedures Policy from TechRepublic Premium is to establish a clear and efficient process for employees to report security breaches, device loss, or data exposure incidents involving personal devices used for work purposes. From the policy: CONFIDENTIAL REPORTING Employees are strongly encouraged to promptly report incidents, and they ...

Cryptocurrency is a popular technological worldwide trend. As with any investing avenue, the revenue one can make dealing in cryptocurrency can vary depending on the time put into the endeavors, market fluctuation, choice of investments, available capital, how loss averse you are, your short- and long-term strategies and other traditional investment factors. Be forewarned, scams ...

Artificial general intelligence, or AGI, is a hypothetical form of AI designed to perform human-level cognitive functions, such as the capacity to self-teach. AGI is regarded as very powerful since it can autonomously solve a wide variety of cognitive tasks, as opposed to weak or narrow AI systems that carry out only particular or specialized ...