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

[Quentin Lydall]

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-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 
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 
by telephone on (+61 3)  1300 002 225.
#####################################################################################
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20080825/7443d107/attachment-0001.html