Mail Merges
The process of preparing an Excel spreadsheet so it is ready to merge into a a Word document.
Steps for Excel Spreadsheet
- Log onto the SOAR Reservation System
- Under "Generate Labels" click the respective "Confirmation Labels" link for FYR, TRF, or INTL students
- Click "Generate Spreadsheet" at the bottom of the session's roster
- Click "Sort & Filter" and then "Custom Sort"
- Sort by Parking, values, and order A to Z
- Save Excel sheet with the date in the O Drive -- O:\Publications & Communications\SOAR\SOAR Publications\2015 - Summer\Confirmations\Session Rosters
- In the O Drive Find the Confirmation Letter
- O:\Publications & Communications\SOAR\SOAR Publications\2015 - Summer\Confirmations
- In Word, under "Mailings" tab select "Start Mail Merge" and "Step by Step Mail Merge Wizard"
- Follow the step by step directions and double-check before printing off
- Using the same Excel spreadsheet from "Steps for Excel Spreadsheet"
- Find the Parking Information Letter in the O Drive and proceed with the mail merge
- Double-check before printing off