turn this in as part of the EXCEL 2 Exercise. There
will be no credit on this unless the records are in alphabetical order
with your name in the right location
We are going to use the grades spreadsheet to feed a merge Document in
WORD. There are a number of options on this such as individual reports,
form letters, printing addresses directly on mailpieces, but just for the
sake of this exercise, we'll generate a page of labels, one for each record,including
the one that has your name on it (in alphabetical order, replacing the
Dennis Adams record)
Preparation of Spreadsheet
On the grades sheet, make sure there is a label for every column in row
4
select the whole range of data, including headings in rows 4 and 5
name the range by insert /name /define. name it reports.
save the spreadsheet
Setup of Merge Document
There are three merges under tools, merge documents, mail merge, and envelopes
and labels. We will use the mail merge option.
1. Create Main Document/ mailing Labels/ active Window
2. Data Source/ Open Data Source / select the grades file, specifiying
the range "reports" that we set up before we got here.
Setup the Main document. Back to 1.
Select label Avery 8167 Return Address 0.5X1.75
On the sample label, type [yourname]'s Reports, section time and <enter>
to get to the next line
This step is important because that's how I can
tell who did it.
Insert merge field <<name>> from the list put in a few spaces
Insert merge field <<total>> from the list
put more data if you want (not too much, it's a small label!)
click okay
3. Merge to new document. Be careful in setting up printing,
as this procedure sets the printer tray to Manual, so you have to
change it to default else the printer will go crazy and everyone
will curse you for jamming up the printer..
Print the resulting new page and turn it in with the 2nd EXCEL assignment.