Software

Images: Send SMTP mail from SQL Server with xp_SMTPSendMail80

By // July 18, 2006, 8:42 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.

    © CNET Networks - Submitted by Joshua Hoskins

  • Basic e-mail in Outlook

    This image shows the format of a basic e-mail as seen in Outlook 2003.

    © CNET Networks - Submitted by Joshua Hoskins

  • Embedding a query in e-mail

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

    © CNET Networks - Submitted by Joshua Hoskins

  • Query results e-mail

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

    © CNET Networks - Submitted by Joshua Hoskins

  • Sending an HTML e-mail

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

    © CNET Networks - Submitted by Joshua Hoskins

  • Receiving an HTML e-mail

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

    © CNET Networks - Submitted by Joshua Hoskins

  • Sending an attachment to multiple recipients

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

    © CNET Networks - Submitted by Joshua Hoskins

  • Receiving an attachment e-mail

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

    © 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

Related Topics:

Software Enterprise Software Developer Open Source Software Mobility Cloud

About Bill Detwiler

Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop supp...