Using the Filter
Using the Filter
This option allows you to send e-mail messages to specific addresses based on multiple criteria, such as text
contained in a field. The filter searches your records, and sends the messages only to those records
that have met the filter criteria. For example, if you want to send a message only to recipients in California:
· Select the State field from the dropdown menu.
· Turn the filter On by selecting one of the 9 available filters in the dropdown box,
· In the box on the right side of the Filter box insert the word CA.
The program will search all records and send the message only to those in CA. The most powerful is the filter "Like" in
combination with (wildcard *). For example, if you want to send a message only to the recipients where area code is (260),
select the following statement <Phone Like 260*>. The wildcard sign * can be used at the beginning or at the end of word
or number. You can always check the SQL statement generated by the filter, by clicking on the Message Editor tab.
The following statements can be used in the program by copy and paste in the
statement window. Change the word Group1 if your data is stored in the group other than Group1.
To send email only to valid email addresses from your last email campaign, use the statement:
select * FROM Group1 Where Status = 'Sent Successfully'
To send email to all recipients that did not ask to be removed from the list Use:
select * FROM Group1 Where Unsubscribe <> 'Yes' OR Unsubscribe IS NULL
To send all unsent emails from your last email campaign use:
select * FROM Group1 Where Status Like 'error*'
To send a message to "Yahoo" recipients only use:
select * FROM Group1 Where Email Like '*yahoo.com'
To send a message to all recipients where Zip number starts with "92" use:
select * FROM Group1 Where Zip Like '92*'
You can find more information about how to use SQL logical operators at :
http://www.multiemail.com 2000-2003 All right reserved