| Word 330 - Use Mail Merge to create Form Letters, Envelopes, Mailing Labels, and Great-Looking Personnel Lists from people-lists that are already stored in Excel 1/2 day Prerequisites: MS Word Level 1 or Equivalent and MS Excel Level 1 or Excel 115 or Equivalent click here to return |
| Topics may include: Create Form Letters from an Excel List Hands on - Create a letter for use with Mail-merge Hands on - Insert mail-merge fields into the letter Hands on - Specify an Excel worksheet as your list source Hands on - Mail-merge to create individualized form letters Hands on - Examine the individual form letters Create Mail Merge Envelopes from an Excel List Hands on - Create an envelope layout Hands on - Add mail-merge fields from an Excel list Hands on - Save the envelope as a template Hands on - Use the envelope template to create a new envelope Hands on - Use your Excel data to create individualized envelopes Create Sheets of Identical Labels with Logos or other Pictures on Them Hands on - Select the appropriate Avery label template Hands on - Create the mailing label page Hands on - Insert your logo or other picture into each mailing label Create Individualized Mailing Labels from an Excel List Hands on - Select the appropriate label template Hands on - Add the mail merge fields Hands on - Replicate the mailing label over the whole sheet of labels Hands on - Control which names on the Excel list get included Hands on - Fill the labels with mailing addresses from your Excel list Create Great Looking Personnel Lists in MS Word, from an Excel List Hands on - Create a Great Looking Personnel List layout Hands on - Replicate the mail merge fields Hands on - Save the empty Personnel List as a MS Word template Hands on - Link the Roster to your Excel list Hands on - Mail-Merge your Personnel List from the Excel data |