Excluding customers with an E-mail address from lists (Mailing labels, etc) |
Top Previous Next |
(From Newsletter #49, Feb 27, 2023)
DISCLAIMER: This article involves Advanced Customizations, which can be technically challenging to get working and is not part of standard support. This is programming and must be done precisely or the results can be unpredictable. This information is provided as a service for those who have the technical skills to work through it -- we cannot help you solve any issues with getting it working. For more information about Advanced Customizations, see the full documentation:
https://campgroundmaster.com/help/overview32.html
When printing mailing labels or envelopes, it makes sense to exclude those who have an E-mail address if you're using E-mail when possible and only mailing hard copies if necessary.
You can use an expression in the Filter that will only include those without the '@' character in the E-mail address field, which effectively excludes any with an E-mail address.
For instance if you're in Reports / Customer Mailing labels....
Click on Reservation Filtering..., then the "Advanced Condition Expression..." button, and enter this expression exactly:
Find(Cust:Cust_Email,"@") = 0
Note that this will be combined with any other reservation filtering selected.
Click Save / OK... and make sure "Use reservations, with optional filtering" is selected (this won't work for customers without reservations).
Now the list should only include people without any E-mail address.
Similarly, to do the filtering when printing reservation receipts.... once you get to Print Reservation Receipts (either through Reports or from right-clicking on a tab view, Print or E-mail for All shown, etc..)... then click "Filtering..." and enter an Advanced Condition Expression as shown above.