Email Campaign System

Email Contents
Enter the From address. Use angle brackets to delineate the SMTP address.	From:
Enter the Reply-To address. Must be a valid Exchange email address	Reply-To:
	Subject:
Wrap any column name returned in the result set with brackets (e.g. [FirstName])	Email Message:	<HTML> <img src="http://www.precisys.com/images/small_logo.jpg" width="336" height="60" alt="Welcome"><BR><BR> <FONT FACE=ARIAL SIZE=3>Precision Systems Consulting Announcement</FONT><BR><BR> <FONT FACE=ARIAL SIZE=2>Saturday, July 31, 2010</FONT><BR><BR> <FONT FACE=ARIAL SIZE=2> Dear [FirstName],<BR><BR> You just received an email from Precision Systems Consulting<br> Email Campaign System. The FirstName that you entered will<br> be in the salutation of the email.<br><br> If you have any questions or need a quote on how you can add<br> this functionality to your Onyx CRM implementation, please<br> contact me directly.<br><br> Regards,<br><br> Chris Bassett<br> <FONT SIZE=2 COLOR=#7a1818>Precision Systems Consulting, LLC<FONT><br> <FONT SIZE=2>email: chris.bassett@precisys.com<br> </FONT> </HTML>
Select which format for the message body when sending the email message	Format:	HTML PlainText
Select the file attachment path	Attachment Path:

Tab 2 is where you specify email sender, reply-to, subject and content. You can preview the content before sending the email.
Content is mergeable with information from the database, as in the example here with [FirstName] A single attachment can be sent from a file that is staged on your Internet Information Server.

©Copyright 2002 - Precision Systems Consulting, LLC. All rights reserved.

Campaign Options
Select the Tracking Code to use	Tracking Code:
Select the Campaign Action to indicate email sent	Enrollment Action:

Campaign Options are where you enroll the customer into an Onyx campaign
Simply choose the Campaign Tracking Code and Campaign Action that you want to add into Onyx for each email recipient.

©Copyright 2002 - Precision Systems Consulting, LLC. All rights reserved.

Target List
Enter in the SQL Statement. This must return the column vchEmailAddress in the result set	SQL Statement	select iIndividualId As CustomerId, vchFirstName As FirstName, vchLastName As LastName, vchEmailAddress FROM vIndividual WHERE vchEmailAddress = 'chris.bassett@precisys.com'
For testing purposes, please enter in your email address	Your email address
For testing purposes, please enter in your First Name.	Your first name