This article covers the steps required to send mailings to specific staff members in conjunction with certain events. The example used here concerns weekend events, and messages only the facilities manager to inform them which buildings will need to be open on the day of the event. 

Create the mailing

First, develop the text of the mailing you'd like to send.

1. From the main navigation, select Deliver.

2. Select New Mailing. In the popup:

   • Name: Give your mailing a descriptive internal name. In this example, Notify Facilities of Weekend Events 

   • Folder: Keep organized by placing the new mailing in an existing folder, or select Other to create a new one.

3. Select Save.

4. Select Edit Message. In the popup:

   • Add a Subject. In this case, Campus Buildings Required for Weekend Event.

   • Compose your message in the WYSIWYG editor.

5. Select Save.
   

Create the recipients list query

This query will:

• Pull events with a dictionary export,

• Filter them to events happening this weekend, and

• Filter recipients based on their GUID

 Create the query

1. Select Edit Recipients List.

2. Select New Query. In the popup:

   • Name: Give your query a descriptive name. In this example, Notify Facilities Weekend Events.

   • Sharing: Select this option if you want to share this query with other users with the query and query base permissions.

   • List Type: Include

   • Type: Configurable Joins

   • Category: Related

   • Base: User
     

3. Select Save.

Create the events export

1. Select Edit Query. 

2. Select Subquery Export.

3. In the popup, configure the following:

   • Name: Events

   • Type: Independent subquery

   • Category: Related

   • Base: Form

   • Output: Dictionary

   • Exports: Create exports for any detail about an event you'd like to pull in to the mailing as merge fields. Note: All export names must be computer-friendly (lowercase, no spaces) for liquid looping purposes.
     

4. Select Save.

Filter for weekend events

1. Create a Subquery Filter that targets this weekend's events.

2. Configure the following settings:

   • Name: Give the subquery filter a descriptive name. In this example, Events Happening This Weekend.

   • Type: Independent Subquery

   • Category: Related

   • Base: Forms

   • Aggregate: Events
     

3. Create filter logic that restricts exports to only events happening this weekend:

   • (

   • IN Folder (add folders as needed)

   • OR

   • IN Template (add templates as needed)

   • )

   • IN Status: Confirmed/Active

   • Start Date: >= today + 1

   • Start Date: <= today +2
     

4. Select Save.

Filter for relevant personnel

If the facilities manger does not yet have a user account in Slate:

1. From the main navigation, select Database, then User Permissions.

2. Select New User.

3. Enter the individual's name and email. 

4. Select Save. A dialog appears saying "This account has not been enabled for access. Do you want to continue?"

5. Select Continue.

6. On the right, under Users & Activity, select Inactive Users.

7. In the page's URL, find the user GUID after /user?id=
   

8. Copy the GUID.

9. If the facilities manager already has a user account in Slate, copy their GUID using the previous method. You can also query on user GUID using the configurable join related base User.

10. Return to the Create a Filter.

11. Select GUID. Select Continue.

12. In the GUID field, paste the facilities manager's user GUID.
    

13. Select Save.

Add liquid looping and merge fields to the mailing

1. Using the breadcrumb navigation, return to the mailing overview page.

2. Select Edit Message.

3. Select the Source button.

4. Add the following to the mailing's HTML:

   {% for event in events %} Date and Time: {{event.startdate}}
   
   Event: {{event.title}} in {{event.location}}
   
   {% endfor %}

📖 Fundamental Liquid Markup and Conditional Logic