[Year 12 IT Apps] OT- Mail merge and word

Tue Aug 26 08:25:42 EST 2008

Thanks Quentin for a simple answer to my question. I have no problem
with mail merge, but with someone taking over my job in a couple of
weeks these sort of quick guides are very helpful to pass on to the non
IT skilled.

Thanks again

Claudia

*********************************************************************

Claudia Graham

VCE Coordinator

Assistant to the Head of Staff (Keilor Campus)

9334 0049 (direct)

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Quentin Lydall
Sent: Monday, 25 August 2008 4:38 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] OT- Mail merge and word

Hi Claudia,

Yes, it's tricky doing fancy stuff, but for ordinary mail merges such as
names/addresses, tickets, certificates, etc, it's really quite easy.

1.       Set up the Excel spreadsheet as your data source.  Give each
column a heading, such as Name, Address, Suburb, State, Postcode.  

2.       Populate the worksheet and save it.

3.       Set up your Word document, having planned where the merged
fields are going to be.

4.       Go into the Mailings tab.

5.       Click on Select Recipients in the Start Mail Merge group of the
ribbon, select Use Existing List..  here drill down to the saved
spreadsheet.

6.       Select the worksheet within the spreadsheet (if applies).

7.       Position your cursor wherever you want the insert a field, then
in the Write & Insert Fields group click on the Insert Merge Field
option. The list of fields drops down.  Select the field.

8.       When all fields are in, you may either Preview Results or
Finish, as you like.

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.

I guess people who don't have Office 2007 can't see it.

Quentin Lydall

Head of ICT

Beaconhills College Valley Campus

30-34 Toomuc Valley Road,

Pakenham

3810

Phone:(03) 5945 0016

P Please consider the environment before printing my email

From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Claudia Graham
Sent: Friday, 22 August 2008 3:12 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] OT- Mail merge and word

Hi all,

Sorry for the OT request, but thought I'd rather post here then reinvent
the wheel!

Does anyone have a short instruction sheet on mail merge with excel in
Office 07?

Thanks

Claudia

*********************************************************************

Claudia Graham

VCE Coordinator

Assistant to the Head of Staff (Keilor Campus)

9334 0049 (direct)

_______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
<http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4html%2
0> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

Overnewton Anglican Community College
A school for the whole family celebrating 21 years of quality education
in the North West of Melbourne. 

 Winner of the 2007 Australian Chamber of Commerce and Business Council
of Australia National Work and Family Award for a Medium-sized Business.

 EOWA Australia's Leading Organisation for the Advancement of Women
(less than 500 employees) in 2005

An EOWA Employer of Choice since 2002.

http://www.overnewton.vic.edu.au/ 

Keilor Campus 
2-30 Overnewton Road 
Keilor, Victoria, 3036 
Tel: 03 9334 0000 
Fax: 03 9336 1835 

Taylors Lakes Campus 
39 - 57 Robertsons Road
Taylors Lakes, Victoria, 3038
Tel: 03 9334 0000
Fax: 03 9390 5144

________________________________

This email is confidential and intended solely for the use of the 
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 Beaconhills College <http://www.beaconhills.vic.edu.au%20>  by
telephone on (+61 3)  1300 002 225.

________________________________

_______________________________________________ 
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
<http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%
20> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc

Overnewton Anglican Community College
A school for the whole family celebrating 21 years of quality education in the North West of Melbourne. 

 Winner of the 2007 Australian Chamber of Commerce and Business Council of Australia National Work and Family Award for a Medium-sized Business.

 EOWA Australia's Leading Organisation for the Advancement of Women (less than 500 employees) in 2005

An EOWA Employer of Choice since 2002.

http://www.overnewton.vic.edu.au/ 

Keilor Campus                                      Taylors Lakes Campus
2-30 Overnewton Road                               39 - 57 Robertsons Road
Keilor, Victoria, 3036                             Taylors Lakes, Victoria, 3038
Tel: 03 9334 0000                                  Tel: 03 9334 0000
Fax: 03 9336 1835                                  Fax: 03 9390 5144
----------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20080826/3134053d/attachment-0005.html