To send emails to only athletes/parents entered into a meet follow the steps below:
  1. Create Meet Entries Report 
Note: See related article Meet Entries Report
  1. Click User-added image to export as a CSV
  2. Open the file
  3. Select the Athlete Name row
  4. Right Click the row
  5. Click Copy
User-added image
  1. Create Registration Report for desired program
  1. Click User-added image to export as a CSV
  2. Open the file
  3. Delete all columns except: Athlete First Name, Athlete Last Name, Athlete Email
User-added image
  1. In C2 type =CONCAT(A2, " ", B2)
User-added image
  1. Click the bottom right hand corner of the cell and drag it down to the end of the column
User-added image
  1. Insert a new column next to column C
  2. Copy the athlete names from meet entry report to this column
  3. Right Click cell D2
  4. Click Paste Special
  5. Click Paste Values 123
User-added image
  1. Select Column D
  2. Click Conditional Formatting
  3. Click New Rule
User-added image
  1. Click Use a formula to determine which cells to format
  2. Type  =COUNTIF($D:$D,$C1)
User-added image
  1. Click Fill
  2. Select a color
  3. Click OK
  4. Click OK again
  5. All athletes who are going to the meet will now be highlighted
User-added image
  1. Create a new CSV file
  2. In Cell A2, type Email
  3. Copy all athlete's emails who are highlighted to the new CSV file in Column A starting with Cell A2
User-added image
  1. Save the file
  2. In Swim Manager, click on Communications
  3. Click Create Email
  4. Click Add
  5. Click Import CSV
  6. Click Choose File
  7. Select the CSV file
  8. Enter list name
  9. Click OK
User-added image
  1. Click Import
  2. Edit and send email
Note: See related article Send Emails