You’ll notice a new Filter Rows box when connecting to a spreadsheet.
This post explains how to use the Filter Rows box and what croatia phone number resource to type to send email to just the rows that match your criteria. Specify one criteria per line, in the format:
ColumnName=Value
For example, if you have a spreadsheet column called Company, and you want to send a mail merge campaign to just everyone who’s Company is “Microsoft”, you would enter:
Company=Microsoft
Instead of the = sign, you can instead use the ~ operator to represent “contains”. For example, let’s say that your email addresses are in a column called Email. You want to send to only @yahoo.com addresses. You would enter:
Email~yahoo
meaning all rows where the Email value contains “yahoo”.
Full List of Operators
Along with = and ~ you can also use these operators:
!= for "not equals"
> for "greater than"
>= for "greater than or equal to"
< for "less than"
<= for "less than or equal to"
~ for "contains"
= for "equals"
Examples
You can use the operators above to compare strings, numbers, and dates. For example, if you have a spreadsheet column called Age, and you wanted to email just the adults in the spreadsheet, you could set:
Age >= 18
Or, let’s say you didn’t have an Age column but instead had a DateOfBirth column. Then you could set:
DateOfBirth <= 1/1/1999
assuming that anyone born before 1/1/1999 is an adult.
Special Values
There are two special values you can use to represent date values. These are:
CurrentDate
CurrentDateIgnoreYear
You can use these values to compare the data in your spreadsheet to the current system date (in the GMT time zone). For example, if you have a column in your spreadsheet called ShipDate, which represents when a customer’s order will be shipped, you could set:
ShipDate=CurrentDate
to pull just the rows where the order’s shipping date is today to let the customer know that their order has been shipped and will arrive soon.
Using CurrentDateIgnoreYear matches just the Month and Day parts of the date t
