Skip to content

TechRepublic

  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
Resources
  • TechRepublic Premium
  • TechRepublic Academy
  • Newsletters
  • Resource Library
  • Forums
  • Sponsored
Go Premium
Popular Topics
  • Top Products
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • Accounting
  • CRM
  • Academy
  • Project Management
  • Innovation
  • Cheat Sheets
  • Big Data
  • Tech Jobs
View All Topics
Go Premium
Software

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

By Bill Detwiler February 27, 2006, 3:05 AM PST Bill Detwiler 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

Daily Tech Insider

If you can only read one tech story a day, this is it.

TechRepublic TechRepublic
  • TechRepublic on Facebook
  • TechRepublic on X
  • TechRepublic on LinkedIn
  • TechRepublic on YouTube
  • TechRepublic on Pinterest
  • TechRepublic RSS
Services
  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information
  • Careers
Explore
  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • Editorial Policy
  • Legal Terms
  • Privacy Policy
© 2025 TechnologyAdvice. All rights reserved.
CLOSE

Create a TechRepublic Account

Get the web's best business technology news, tutorials, reviews, trends, and analysis—in your inbox. Let's start with the basics.

Already registered? Sign In
Use Facebook
Use Linkedin

* - indicates required fields

CLOSE

Sign in to TechRepublic

Not a member? Create an account
Use Facebook
Use Linkedin

Lost your password? Request a new password

CLOSE

Reset Password

Please enter your email adress. You will receive an email message with instructions on how to reset your password.

Check your email for a password reset link. If you didn't receive an email don't forgot to check your spam folder, otherwise contact support.

Back to login
1 Finish Profile
2 Newsletter Preferences
CLOSE

Welcome. Tell us a little bit about you.

This will help us provide you with customized content.

No thanks, continue without
1 Finish Profile
2 Newsletter Preferences
CLOSE

Want to receive more TechRepublic news?

Newsletter Name
Subscribe
Daily Tech Insider
Daily Tech Insider AU
TechRepublic UK
TechRepublic News and Special Offers
TechRepublic News and Special Offers International
Executive Briefing
Innovation Insider
Project Management Insider
Microsoft Weekly
Cloud Insider
Data Insider
Developer Insider
TechRepublic Premium
Apple Weekly
Cybersecurity Insider
Google Weekly
Toggle All
No thanks, continue without

You're All Set

Thanks for signing up! Keep an eye out for a confirmation email from our team. To ensure any newsletters you subscribed to hit your inbox, make sure to add [email protected] to your contacts list.

Back to Home Page
×