get_field_labels: SELECT field_name, short_message FROM message WHERE table_name = 'help' AND message_type = 'Field Label' AND language = 'US_English'
| Long Help |
The mailing label system provides the ability to create a
printable page that will fit the Avery 5160 mailing label
sheet of labels. The initial page provides two selection options:
- Scope: Filter selection of which people to include
- Entire Roster: Used as a check to proof the list, mainly for cleanup.
- Newsletter Subscribers: Each person record has an attribute of Newsletter which can
either be Y or N. This option collects those who are opted in where this value
is Y.
- Member Subscribers: Same as above, and they are in the member table.
- Opted Out Members: Same as above, but their Newsletter is N.
- All Prospects: Anyone in the people table whose Membership Progress is not Member.
- Opted In Prospects: As above but the newsletter attribute is set to N.
- Opted Out Prospects: As above but the newsletter attribute is set to N.
- All Members: All members.
- Opted In Members: Members whose newsletter attribute is set to Y.
- Paid Members: Members whose current dues status is Paid Member.
- Recent Attendees: Anyone attending the last 2 socials.
- Past Attendees: Anyone attending a social since the system went online in July 2025.
- Last Event Attendees: Anyone attending the last social.
- Delivery: Whether the output goes to:
- See To Print: You see a printable sheet as it will appear and print it to your printer.
- Save To Website: Save the output to the website, archiving it to
https://matesanddates.org/maillists where anyone
can retrieve it.
- Download PDF: Directly downloads it without inspecting it.
You make the two selections and click on the button labeled Print and the database
selects the set of people/couples to mail to and provides the list in the delivery format
you choose. The key filters work on the Newsletter attribute of the person record
(via the Who utility) and the relationships from the
Members utility.
|