<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="http://schemas.microsoft.com/! exchange/services/2006/messages">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:"Franklin Gothic Medium";
panose-1:2 11 6 3 2 1 2 2 2 4;}
@font-face
{font-family:"Arial Black";
panose-1:2 11 10 4 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:36.0pt;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast
{mso-style-priority:34;
mso-style-type:export-only;
margin-top:0cm;
margin-right:0cm;
margin-bottom:10.0pt;
margin-left:36.0pt;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1963606393;
mso-list-type:hybrid;
mso-list-template-ids:901275178 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><a name="_MailEndCompose"><span style='color:#1F497D'>Hi
Claudia,<o:p></o:p></span></a></p>
<p class=MsoNormal><span style='color:#365F91'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#365F91'>Yes, it’s tricky doing fancy
stuff, but for ordinary mail merges such as names/addresses, tickets,
certificates, etc, it’s really quite easy.<br>
<br>
<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpFirst style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>Set up the Excel spreadsheet
as your data source. Give each column a heading, such as Name, Address,
Suburb, State, Postcode. <o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>Populate the
worksheet and save it.<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>Set up your Word
document, having planned where the merged fields are going to be.<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>4.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>Go into the Mailings
tab.<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>5.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>Click on Select
Recipients in <b>the Start Mail Merge</b> group of the ribbon, select Use
Existing List.. here drill down to the saved spreadsheet.<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>6.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>Select the worksheet
within the spreadsheet (if applies).<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>7.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>Position your cursor
wherever you want the insert a field, then in the <b>Write & Insert Fields</b>
group click on the Insert Merge Field option. The list of fields drops down.
Select the field.<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span
style='color:#365F91'><span style='mso-list:Ignore'>8.<span style='font:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style='color:#365F91'>When all fields are
in, you may either <b>Preview Results</b> or <b>Finish</b>, as you like.<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpMiddle><span style='color:#365F91'><o:p> </o:p></span></p>
<p class=MsoListParagraphCxSpMiddle style='margin-left:0cm'><span
style='color:#365F91'>Office 2007 has really simplified the merge process for
simple merges. Just look along the ribbon. At left you can set up labels or
envelopes if you need to, then moving right you start, then write & insert
fields, Preview Results and Finish.<br>
<br>
<o:p></o:p></span></p>
<p class=MsoListParagraphCxSpLast style='margin-left:0cm'><span
style='color:#365F91'>I guess people who don’t have Office 2007 can’t see it.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='font-family:"Franklin Gothic Medium","sans-serif";
color:#365F91'>Quentin Lydall<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#365F91'>Head of ICT<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#365F91'>Beaconhills College Valley
Campus<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:8.0pt;color:#365F91'>30-34
Toomuc Valley Road,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:8.0pt;color:#365F91'>Pakenham<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:8.0pt;color:#365F91'>3810<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#365F91'>Phone:(03) 5945
0016<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:18.0pt;font-family:Webdings;
color:green'>P</span><i><span style='color:navy'> </span></i><i><span
style='color:green'>Please consider the environment before printing my email</span></i><span
style='font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b>On
Behalf Of </b>Claudia Graham<br>
<b>Sent:</b> Friday, 22 August 2008 3:12 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> [Year 12 IT Apps] OT- Mail merge and word<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Hi all,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Sorry for the OT
request, but thought I’d rather post here then reinvent the wheel!<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Does anyone have a
short instruction sheet on mail merge with excel in Office 07?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'>Claudia<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:7.5pt;font-family:"Arial Black","sans-serif";
color:maroon'>*********************************************************************</span><span
lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:7.5pt;font-family:"Arial Black","sans-serif";
color:maroon'>Claudia Graham</span><span lang=EN-AU style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:7.5pt;font-family:"Arial Black","sans-serif";
color:maroon'>VCE Coordinator</span><span lang=EN-AU style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:7.5pt;font-family:"Arial Black","sans-serif";
color:maroon'>Assistant to the Head of Staff (Keilor Campus)</span><span
lang=EN-AU style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:7.5pt;font-family:"Arial Black","sans-serif";
color:maroon'>9334 0049 (direct)</span><span lang=EN-AU style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-AU style='font-size:12.0pt;font-family:"Times New Roman","serif"'>_______________________________________________
<br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a
href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4html%20">http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></span></p>
<p align=center style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:
7.5pt;margin-left:0cm;text-align:center'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:blue'>Overnewton Anglican Community
College</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><br>
A school for the whole family celebrating 21 years of quality education in the
North West of Melbourne. </span><o:p></o:p></p>
<p align=center style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:
7.5pt;margin-left:0cm;text-align:center'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:blue'> Winner of the 2007
Australian Chamber of Commerce and Business Council of Australia National Work
and Family Award for a Medium-sized Business.</span><o:p></o:p></p>
<p align=center style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:
7.5pt;margin-left:0cm;text-align:center'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:blue'> EOWA Australia's Leading
Organisation for the Advancement of Women (less than 500 employees) in 2005</span><o:p></o:p></p>
<p align=center style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:
7.5pt;margin-left:0cm;text-align:center'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:blue'>An EOWA Employer of Choice since
2002.</span><o:p></o:p></p>
<p align=center style='mso-margin-top-alt:7.5pt;margin-right:0cm;margin-bottom:
7.5pt;margin-left:0cm;text-align:center'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif";color:blue'><a
href="http://www.overnewton.vic.edu.au/">http://www.overnewton.vic.edu.au/</a></span>
<o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="57%"
style='width:57.0%'>
<tr>
<td width=310 style='width:232.5pt;padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal align=center style='text-align:center'><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:blue'>Keilor
Campus <br>
2-30 Overnewton Road <br>
Keilor, Victoria, 3036 <br>
Tel: 03 9334 0000 <br>
Fax: 03 9336 1835 <br>
</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</td>
<td width=310 style='width:232.5pt;padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal align=center style='text-align:center'><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:blue'>Taylors
Lakes Campus <br>
39 - 57 Robertsons Road<br>
Taylors Lakes, Victoria, 3038<br>
Tel: 03 9334 0000<br>
Fax: 03 9390 5144</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
<HR>
<DIV>This email is confidential and intended solely for the use of the
<BR>individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of Beaconhills
College. If you are not the intended recipient, be advised that you have
received this email in error and that any use, dissemination, forwarding,
printing, or copying of this email is strictly prohibited. If you have
received this email in error please notify <A
href="http://www.beaconhills.vic.edu.au ">Beaconhills College</A> by telephone
on (+61 3) <STRONG>1300 002 225</STRONG>.<BR></DIV>
<DIV></DIV>
<HR>
</body>
</html>