Use an Existing Query to Set Up a Bulk Email [DRAFT]

[THIS IS CURRENTLY A DRAFT KB UNDER REVIEW] This KB document goes over how to create a bulk email starting from an existing query in Slate.

Important note: in order to send bulk emails out of Slate, you need to have Graduate Coordinator / Query Manager permissions and take additional training. Please review the Overview of Bulk Emailing in Slate via Deliver KB Document for more details.

Overview & Example Case Study

To successfully send your bulk email, you should go through these five steps:

  1. Compile List: Determine which of your applicants need to receive this email and prepare this list
  2. Write Email: Draft your email, using the proper merge fields to personalize the email and settings to make sure it isn't marked as spam
  3. Preview Email: See what the email will look like and send a test email to yourself
  4. Submit Email: Send the email out to your desired recipients
  5. Verify Email: Check to make sure your email has properly sent and review its performance

Below, we go through each of these steps using the following case study as an example:

 I want to send an email to all of our unsubmitted applications for an upcoming term to remind them of the application deadline.

 

STEP 1: Compile List

We're going to compile the list of applicants to email by using a Homepage query.

  1. Navigate to the Slate homepage. 

  2. Select the term for the "All Unsubmitted Applications" homepage query, as shown in the screenshot below. (You could substitute any other query for this step if you wish to email a different list of students.)
    Screenshot of the Slate homepage, highlighting the "All Unsubmitted Applications" link in teh Homepage Queries list.

  3. When you get to the query page, select the "Run Query" button. If you wish to specify the term for the All Unsubmitted Applications query, you can add the term code as shown in the screenshot below, where the Term Code field has been set to 1272 (Fall 2026).
    Screenshot showing the All Unsubmitted or Unpaid Applications query, with 1272 typed into the Term Code field. The Run Query button has a cursor over it.

  4. After the query results populated, this is a good time to review to make sure this list is looking correct. Please note that you will not be able to delete  any individual row from this list; the mailing will go to everyone on this list. Once you are sure you have the correct applicants in your query, select the Output dropdown at the top of the page and select "Deliver Mailing."
    Screenshot showing query results, The Output dropdown has been selected and the cursor is over the Deliver Mailing option.

  5. With "Deliver Mailing" selected as the Output, select the "Export" button, as shown in the screenshot below.
    Screenshot of the query results with Deliver Mailing now selected. The Export button is highlighted with the cursor over it.

  6. In the Deliver Mailing window that pops up, make sure to do the following:
    • Rename the mailing: The name of this mailing will default to “Email Batch Applications.” We strongly recommend you give it a more unique name so you may more easily find it later if needed. For organizational purposes, we would suggest the following naming conventions: [Entry Term(s)] - [Program(s) if specifying] - Mailing Purpose.
      As shown in our example, we've renamed the mailing: Fall 2026 - Deadline Reminder
    • Change the action to "Copy results into mailing as static recipient list": This is crucial! If you do not select this option, it is possible that your mailing list may change from what you've already created. By changing this setting, no applicant will be added or removed from the list you've created.
      Screenshot showing the Deliver Mailing pop up window, with directions pointing to the Name field to rename it, and direction pointing to the remember to change the action to "Copy results into mailing as static recipient list."

  7. With your mailing renamed and "Copy results into mailing as static recipient list" selected, you can select the "Submit" button to move onto the next step.
    Screenshot showing the Deliver Mailing pop up window, and the cursor over the Submit button in the bottom left corner.

STEP 2: Write Email

After completing Step 1 above, complete the following steps to compose your email message:

  1. Select the "Edit Message" button located in right hand side of the screen, as highlighted in the screenshot below.
    Screenshot showing the mailing window, with the Edit Message button on the right side of the screen highlighted.

  2. In the Edit Message window that appears, make sure to edit the "Sender" field. THIS IS IMPORTANT. The sender defaults to admissions@grad.wisc.edu unless you change it. Change it to your preferred email @gradmail.wisc.edu account or service account (you may need to set this up). Optionally, in the "Reply To" field, you can add a different email address to have responses sent to.
    Screenshto showing the Edit Message window, highlighting the Sender field which needs to be updated to a different email address.

  3. In the "Recipient" field, make sure to click and drag the "Email" export from the list of merge fields on the right, as shown in the screenshot below. The list of merge fields on the right side of the Edit Message window correspond to the columns/exports from the query you chose and are listed in alphabetical order.
    Screenshot of the Edit Message window, showing the Email merge field from the list of merge fields on the right side, being dragged into the Recipient field near the top of the window.

  4. In the "Subject" field, create an informative subject for your email. Pro-tip: try to avoid urgent language such as "act now" or "must reach deadline" as these types of phrases can trigger email clients to treat your message like junk or spam mail. Optionally, in the "Preheader" field you can add text that will show up as preview text in an email client.
    Screenshot of the edit message portal, highlighting the Subject field.

  5. Compose your message. If you wish to add merge fields, you can click and drag the merge field into the email editor or use the double brackets button in the tools bar above the email editor which looks like this: { } Please note that you may want to cautious about using the {{Plan-Subplan}} field -- sometimes it is better to just use the program name if you know exactly which program your list of students is applying to. You can also use the paperclip icon in the bottom right hand corner to add an attachment to the email.
    Screenshot showing the Edit Message window, with text now in the message section. Merge field Preferred is being used.

  6. When your email looks ready, select the "Save" button in the bottom left hand corner of the window.
    Screenshot of the Edit Message window with the Save button highlighted in the bottom left of the window.

STEP 3: Preview Email

To make sure your email is working as expected, follow the steps below to preview your email.

  1. Scroll down to the Message section of the mailing editor. There you will see a random example email displayed with the merge fields bringing in the recipients information. By selecting the "Preview Message" button, another random example recipient's information will be brought into the preview email so you can see what information changes.
    Screenshot of the mailing section of slate, showing the preview message with merge fields highlighted.

  2. You can send an example message to yourself or a colleague following the directions below:
    • Select the "Send Message" button located on the right side of the screen underneath the "Preview Message" button, as shown in the screenshot below
      Screenshot highlighting the Send Message button on the right side of the window.

    • In the window that pops up, you can fill in a custom recipient email (for example, your own @wisc.edu email). If you wish, you can also replace the subject by selecting the "Prepend Subject" checkbox and providing a new subject, as shown in the screenshot below.
      Screenshot of the Send Message window, where you can prepend the subject line and send a test message to yourself.
    • Select the send button in the bottom left screen. It will then send a test message to the email address provided that you can check.

  3. If your merge fields are not bringing in the desired information or not working as expected, or if your message just isn't quite right, you can go back and edit your message by selecting the same "Edit Message" button from Step 2 above.

  4. Repeat these steps as necessary until you are satisfied with the message. (Perhaps, for example, you noticed your message stated it was for "December 1, 2026" when it should have just said "December 1.")

STEP 4: Submit Email

Once you've set up and previewed your mailing, now it is time to send!

  1. Select the "Send Mailing" button, which is located underneath the "Edit Message" button on the right side of the screen, as shown in the screenshot below.
    Screenshot of the mailing window, highlighting the Send Mailing button on the right side of the window.

  2. Review the information presented in the Send Mailing pop up window that appears:
    • Pre-Flight Checks: are there any errors spotted in the mailing? If there are unfamiliar errors here that you cannot fix yourself, please reach out to admissionstaff@grad.wisc.edu and provide the name of the mailing and a screenshot of the error you are receiving. In the example in the screenshot below, there is no warning message.
    • Estimated Recipients: Does the number of recipients appear accurate? If not, you may have made an error in compiling your list. 
    • Recipient Lists: Does the listed recipient list look accurate? Does the timestamp provided match up with when you built this email list?
    • Review: Make sure this box is unchecked unless you wish for someone from the Graduate School Admissions office to review the message before sending out.
    • Outbox: Make sure this box is unchecked unless you wish to not deliver this message at the moment.
    • Frequency: Select Send mailing once always. Due to the number of messages and users likely using the Deliver platform, we do not want anyone using automatically sending messages. If you try to send multiple emails, you will lose your permissions to send emails out of Deliver.
    • Timing: You can choose to send at a specific time, but typically just select Send Now, which is the default.
    • Deduping: Keep this at "send only one message/recipient" to ensure that if you accidentally added a person to your list twice they won't receive two emails. However, if you expect that one of your applicants should be sent the message twice (perhaps they applied to two of your different programs) you can change this setting to "Do not dedupe messages."
      Screenshot showing the Send Mailing window, as described above.


  3. If ready to send, select the "Send Mailing" button.

  4. If there were warnings in your Pre-Flight checks, the system will require you to type in "SEND AND IGNORE WARNINGS" in order to send the mailing. If you are unsure of this decision, please reach out to Graduate School Admissions to help you review your mailing at admissionstaff@grad.wisc.edu Screenshot shows the warning message and requiring the sender to type in the message "SEND AND IGNORE WARNINGS"

STEP 5: Verify Email

Your email is sent! Great job! Now it is time to review to make sure it worked out.

There are two ways you can review the mailing: (1) reviewing an individual recipient's Timeline, and/or (2) review the mailing in Deliver to see overall results.

  1. Review an individual recipient's Timeline:
    • Search for an applicant who should have received the mailing in Slate
    • Go to the applicant's Timeline tab, where you will be see a list of all of the mailings sent to this applicant.
    • Find the email sent in the list, which should be near the top if sent recently, as shown in the screenshot below. (Alternatively you could use the search bar and type in the mailing's subject.)
      Screenshot of Bucky Badger's Timeline tab in Slate, where a list of interactions are listed. At the top is the recent mailing sent.

    • If you select the mailing, you'll be able to see the email as it was sent to the applicant.
      Screenshot of the email as it was sent to Bucky Badger.


  2. Review the mailing in Deliver to see overall results:
    • From the homepage in Slate, select the Deliver icon in the top menu, which looks like a megaphone, as shown in the screenshot below.
      Screenshot of the Slate Homepage, highlighting the Deliver icon

    • Once in the Deliver section of Slate, in the right hand menu select the "Completed" link, which will list all of your sent mailings.
      Screenshot of all of the mailings listed in Deliver module, with a section on the right highlighted showing the Completed link.

    • From the list, select the mailing you wish to review.
      Screenshot showing the recent mailing at the top of the completed mailings.

    • You will land on the mailing review page, where you can see how your message worked, such as how many messages were successfully delivered, which ones bounced, and if there were any clicks (if you had provided links in your message).
      Screenshot of the Mailing review page, where you can review things like how many messages were sent and delivered successfully or how many bounced.

 



Keywords:
Email, slate, bunch, bulk, group, multiple, Deliver, merge, emailing, query, mailing 
Doc ID:
155825
Owned by:
Eric L. in Graduate School
Created:
2025-10-18
Updated:
2025-10-18
Sites:
Graduate School