Web+ Tutorial

Lesson 7.2 - Sending e-mail using query results

Syntax

<webMail [FROM=SenderEmailAddress] TO=RecepientEmailAddress

[CC=CopyToEmailAddress] [SUBJECT=Subject] [TYPE=Type] [QUERY=QueryName] [MAXROWS=MaximumNumberOfRows] [GROUP=SetOfRecords] [SERVER=SMTPServerType] [PORT=TCP/IPProtOnSMTPServer] [TIMEOUT=NumberOfSeconds]>
...

</webMail>

Example

<webDbQuery NAME="Customer List" DATASOURCE="Customer DB"

SQL="Select * From CustomerTable">

<webMail QUERY="Customer List"

FROM="webmaster@webplus.com"
TO="sales@webplus.com"
SUBJECT="Web+ Sales Report">

Here is a list of people who have inquired about Web+ Forums over the last 3 days.

<webPrint>

#LastName#, #FirstName# #CompanyName# - #Email#

</webPrint>

Regards,

webmaster,
webmaster@webplus.com

</webMail>

Exercise

This example is for your reference. You can try it on your own system.

You can try out some Web+ code of your own here.