Let’s learn how to mail m erge Like A Pro

1. Let’s learn how to mail merge Like A Pro

2. Why Mail Merge?

3. Objective Team Members will be able to: effectively use Excel and Word to quickly (ie: in a matter of seconds) create personalized documents, letters, labels, lanyards, stickers, reminders, etc. for program activities…

4. What is mail merge?

5. Simple Steps • Set up Excel • Set up Word • Merge ‘em

6. 1. Set Up Excel

7. 2. Set Up Word Depending on the document: • A letter: Write the letter, leave space for things you want filled in • Labels: Just open word

8. 3. Merge ‘Em

9. 3. Merge ‘Em Pick what you want. If it’s labels, pick the size

10. 3. Merge ‘Em

12. 3. Merge ‘Em

13. 3. Merge ‘Em FILL IN THE SPACES Dear ______, I’m mergin’ like a Boss Thanks, Kevin

14. 3. Merge ‘Em Open it in a new document Just print it!

15. Let’s do it now. • Set up Excel • Set up Word • Merge ‘em

16. Objective Team Members will be able to: effectively use Excel and Word to quickly (ie: in a matter of seconds) create personalized documents, letters, labels, lanyards, stickers, reminders, etc. for program activities…

17. Mergin’