back to assignments
Mail Merge Project using a "friends
and family" contact list.
You can use the
Data Merge Manager to create form letters, mailing labels, envelopes, or catalogs.
The Data Merge Manager guides you through organizing the address data, merging
it into a generic document, and printing the resulting personalized documents.
Completed project shall consist
of the following (Click to view a samples of each piece.)
Form letter requirements:
- Date
- recipient address
- personal salutation
- multi-paragraph body with one item from the data source such as birthday,
cell phone number, favorite color, etc.
- closing
- border or horizontal/vertical rule
- watermark
- proper conventions
- Turn in hard copy of letter printed from the field view, not from preview
of data. ie: <<name>>
Again, this letter should demonstrate your skills and fluency with the
tools available in Word. Use your creativity to compose a letter that has
both strong content (language arts!) and strong design.
Data Source requirements:
- Worksheet one (contacts): print-ready format (title, borders, colors, proper
row and column spacing, etc.)
- Worksheet two (contacts no title): no title. (Copy sheet one and remove
title)
- unique worksheet names
- labeled columns as per example
- 4 comments
- filter (autofilter)
- sort (F.name or L.name ascending order)
- minimum 15 different contacts and 15 duplicated contacts
- combine first and last names using formula
- Know how to: move columns or rows, format cells for alignment & number,
show/hide data, split columns/rows, fill, create a fomula
- Turn in hard copy of sheet one and one individual record printed. Fit to
one sheet of paper and print comments on page. Include your name and date
in the header and file name in the footer. Here's how to print:
- Directions for printing:
*Save
-Select print area (highlight cells with data only)
After the area is selected: File>Print...Set Print Area
For the remaining stuff go to:
(File>Page Setup...)
*Orientation: Portrait
*Scaling: Fit to one page
*Center on page
*Header & Footer (as per instructions)
*Comments=as displayed on sheet
*Print
*Save again
Mailing Label requirements:
- 30 contacts merged to address label (may copy and paste your own address
up to 15 times)
- designed for Avery template 8160
- complimentary text color, font and clipart
- turn in hard copy
- save a copy as a PDF file (File>Print>PDF> "Save
as PDF") in appropriate "turn in folder" on server for color
printing
The following is taken directly from MS Word Help:
How do I start a data merge?
To complete the basic process, you:
1. Open or create a main document, which contains the generic information that
you want to repeat in each form letter, mailing label, envelope, or catalog.
2. Open or create a data source, which contains the data that varies in the
merged documents — for example, the name and address of each recipient
of a form letter. The data source can be an existing spreadsheet, database,
or text file, or a Word table that you create by using the Data Merge Manager.
3. In the main document, insert merge fields, which are placeholders that tell
Microsoft Word where to insert data from the data source.
4. Merge data from the data source into the main document. Each row (or record)
in the data source produces an individual form letter, mailing label, envelope,
or catalog item. You can send the merged documents directly to a printer, or
collect them in a new document so you can review and print them later.
Step-by-step instructions are available in Microsoft Word Help. Search
for Data Merge Manager or view instructions
here.
back to assignments