Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Software

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

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

Image
1
of 8

xp_SMTPSendMail80: Sending a basic e-mail
xp_SMTPSendMail80: Sending a basic e-mail
Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

© CNET Networks - Submitted by Joshua Hoskins

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.

© CNET Networks - Submitted by Joshua Hoskins
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.

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

Embedding a query in e-mail

This screenshots shows the format for embedding a query within an e-mail.

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

Query results e-mail

This image shows the receipt of the e-mail with the embedded query.

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

Sending an HTML e-mail

This picture shows the syntax of sending an HTML-formatted e-mail with an embedded query.

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

Receiving an HTML e-mail

This screenshot shows the receipt of the HTML-formatted e-mail with the query embedded.

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

Sending an attachment to multiple recipients

This picture shows the syntax to use when sending an attachment and sending to multiple recipients.

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

Receiving an attachment e-mail

This image shows an e-mail received from xp_SMTPSendMail80 with an attachment.

  • Software
  • Account Information

    Share with Your Friends

    Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

    Your email has been sent

Share: Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80
Image of Bill Detwiler
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

TechRepublic Premium

  • TechRepublic Premium

    Enterprise IoT calculator: TCO and ROI

    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 ...

    Downloads
    Published:  June 6, 2023, 4:00 PM EDT Modified:  June 7, 2023, 9:15 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Employee political activity policy

    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 ...

    Downloads
    Published:  June 6, 2023, 4:00 PM EDT Modified:  June 7, 2023, 8:42 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Diversity and inclusion policy

    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 ...

    Downloads
    Published:  June 5, 2023, 4:00 PM EDT Modified:  June 6, 2023, 9:27 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Development lifecycle policy

    Software development is a complex process that involves a specific series of steps (known as the development lifecycle) to transform a concept into a deliverable product. The steps involved with creating the finished product must be carefully adhered to yield the best results, reduce inefficiencies and maximize customer satisfaction. The purpose of this policy from ...

    Downloads
    Published:  June 5, 2023, 4:00 PM EDT Modified:  June 6, 2023, 9:15 AM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice