I'm looking for a way to send an email conditionally.

Specifically, I want to run a SQL query and, depending on the result, send the email.

Is there a way to do that?

Well, can you state the SQL query here? Is this SQL query going to be on a combobox or textbox? Depending on which field type it is, you can either create an email based on that question's response or use client side javascript to set a hidden field and based it on that hidden field's response. -- David

Sure.

The form collects names and email addresses.  When the user clicks the submit button there are 3 completion events.

1.  Dynamic SQL Statement: If the user's email address has not already been entered in our database table, it is added.  This is a

if (select count(email) from myTable where email='$(Email)')=0

INSERT INTO  {databaseOwner}[{objectQualifier}NewsletterSubscribers]([UniqueCompletionID],[ResponseDateTime],[UserID],[IPAddress],[FirstName],[LastName],[Email],[State])VALUES ('$(UniqueCompletionID)',GetDate(),$(UserID),'$(IPAddress)','$(FirstName)','$(LastName)','$(Email)','$(State)')

2.  Email Event.  I'd like to send the email only if the first event resulted in a database insert

3.  Redirect Event.  This one always redirects.