KidsGiG Nametags
1. Go to your kidsgig page
2. Change your view to "emergency info"
3. Export your view as a CSV file (DO NOT EXPORT AS EXCEL)
4. Open the CSV you just exported
Click "Downloads"
5. Click "File"
Click "Save As..."
6. Click the File Format: pop up button
Click "Excel Workbook (.xlsx)"
Click "Save"
7. Click this close button
8. In Teams/OneDrive access the file "mail merge gig labels template.docx"
mail merge gig labels template.docx
DO NOT SAVE ANY EDITS YOU MAKE TO THIS FILE
9. Click "Options..."
10. Click "Remove Data/Header Source"
11. Click "Mailings"
12. Click "Select Recipients"
13. Click "Use an Existing List..."
14. Pick the Excel document you made from your CSV
15. Click "Open"
16. Click "Yes"
17. Click "OK"
18. Click "Preview Results"
19. Click this pop up button
Click "FR_Allergies"
20. Click "OK"
21. Click this pop up button
Click "First"
Click "OK"
22. Click this pop up button
Click "Last"
Click "OK"
23. Click "Finish & Merge"
24. Click "Edit Individual Documents..."
25. This is where you will need to proof your labels and make sure the formatting looks correct. Long form answers may cause labels to spill over onto a 2nd label.
26. To print, Click "File"
27. Click "Save As..."
28. Click this pop up button
Click "PDF"
29. Name your PDF
30. Click "Export"
Alert: DO NOT SAVE THE WORD DOCUMENT THAT SHOWS ONE LABEL. You are free to save the PDF file and the Word doc that comes out as "Letters1"