Mail Merge - Western Sydney University


Adapted from

PDU Learning Guide

Word 2007 Advanced Lesson 2

Mail Merge .....Rather than typing the same information repeatedly you can set up a mail merge between the Student Academic Misconduct Worksheet and Summary Record. There are four steps to a mail merge:  Create the Main Document- a document which contains the identical information you wish to send to each person (in this case it’s the ‘Summary Record’).  Create a Data document ... which contains a list of all the information that varies.... (In this case the Student Academic Misconduct Worksheetyou will need to have entered the relevant data in the spreadsheet for the mail merge to work).  Indicate on the Summary Record where you want the variable information to be displayed. (You will need to type in the College and School names and save the document!)  Merge the two documents together. ...

To perform mail merge into the SUMMARY RECORD

Open the Summary Record document  From the Mailings tab, click on Start Mail Merge command.  Select Step by Step Mail Merge Wizard from the drop down list. Note the Mail Merge Task Pane opens

The main document

 Choose Letters under Select document type  Click on Next: Starting Document at bottom of Task Pane and choose one of the following options:  Choose Start from existing document  Click on Use Existing Document (the Summary Record)

The recipients

 Click Next: Select Recipients at bottom of task pane and choose one of the following options:  Choose Use an existing list. o Click Browse and locate and select your Student Academic Misconduct Worksheet. o Make sure you have the right one. o Click OK.



Adapted from Word 2007 Advanced Lesson 2

PDU Learning Guide

 Deselect all by clicking on the tick box beside Data Source, then check only the lines you wish to merge (see below).

Inserting merge fields

 Click Next: Write your letter at bottom of Task Pane  Place your cursor where you want to insert each of the information fields in your SUMMARY RECORD document  Click on More Items  Click Student Name to insert student name in the appropriate blank cell.  Click SID to insert Student Identification Number in the appropriate blank cell.  Repeat process for all other fields in the Summary Record.  Save if you wish to.

The merge

 Click Next: Complete the merge at the bottom of the Task Pane  You can now Print or Edit individual Summary Records Note Word only shows you one of the merged letters here, but when you press Print, all letters will go to the printer. If you select Edit individual letters, all of the merged letters will be displayed in a separate document.

Save the documents individually. You will need to do this so that you can add the outcome letter to each before TRIMming them to the student and meeting files.


Mail Merge - Western Sydney University

Adapted from PDU Learning Guide Word 2007 Advanced Lesson 2 Mail Merge .....Rather than typing the same information repeatedly you can set up a mai...

180KB Sizes 17 Downloads 14 Views

Recommend Documents

Mail Merge - Briar Cliff University
Click on the Mailings tab. · In the Start Mail Merge group, click on the down arrow at the bottom of the Start Mail Mer

HIE | Publications - Western Sydney University
Ellsworth DS, Anderson IC, Crous KY, Cooke J, Drake JE, Gherlenda AN, Gimeno TE, Macdonald CA, Medlyn BE, Powell JR, Tjo

Sensing mail with mail merge
This manual shows you step by step how to do this, and how to make a selection in a list of recipients so that your e-ma

Child Friendly Bolivia - Western Sydney University
About 63% of the Bolivian population lives in urban areas; of this group, 61% lives in slums. Children ..... Metodologí

Reclaiming Australian Multiculturalism - Western Sydney University
Sep 8, 2016 - 'Reclaiming Australian Multiculturalism: policy and practice in a .... The initial concept of multicultura

OLT_LaTS summary_Criterion Wkshop - Western Sydney University
University), A/Prof Ian Solomonides (Macquarie University), Prof Suzi Vaughan (Queensland. University of Technology). St

Yiye LU - ResearchDirect - University of Western Sydney
May 27, 2014 - materials for Chinese learning, specifically for the English-speaking leaners. The. Character films could

ASEARC Proceedings - University of Western Sydney
These proceedings contain the papers of the Fourth Applied Statistics Education and Research Col- laboration (ASEARC) Co

mail merge: cover letters - Loyola University Chicago
STEP 1. • Open a new Microsoft Word document. On the menu bar at the top, click on Tools. From the pull down menu, sel

Mail merge instructions - University of Houston
a) Word 2007 and Word 2010. Select the Mailings tab -> click the Start Mail Merge button-> select Step by Step Mail Merg

Watch movie | Varies with device | Cat Girl Nuku Nuku OVA Episode 5 English Dubbed