Showing Page:
1/1
Mail Merge Assignment
1) Complete the letter and mail merge in “Practice” of the Mail Merge lesson.
2) *Create a personal data source in Excel with the following data. Input
data for a minimum of 10 people. See details below.
a. Using this data source create labels label for a party. Include a
picture. Save this file as detailed in the “Create Envelopes and
Labels tutorial.
b. Using this data source create a mail merge for envelopes with
address and return address. Save file as detailed in the “Create
Envelopes and Labels” tutorial
Things to turn in:
1) Mail merged letters from “practice”
2) Data source for “practice” letters.
3) Excel data source
4) Merged labels
5) Merged envelopes
* Create personal data source in Excel.
Column A Courtesy title (Mr., Mrs., Ms., Dr., etc.)
Column B First name
Column C Middle name or initial (skip if none)
Column D Last name
Column E Greeting (How do you address this individual in person?)
Column F Street address (number and street)
Column G City
Column H State (Use two-letter state abbreviation)
Column I ZIP (5 or ZIP+4)
Column J Home area code
Column K Home telephone

Unformatted Attachment Preview

Mail Merge Assignment 1) Complete the letter and mail merge in “Practice” of the Mail Merge lesson. 2) *Create a personal data source in Excel with the following data. Input data for a minimum of 10 people. See details below. a. Using this data source create labels label for a party. Include a picture. Save this file as detailed in the “Create Envelopes and Labels tutorial. b. Using this data source create a mail merge for envelopes with address and return address. Save file as detailed in the “Create Envelopes and Labels” tutorial Things to turn in: 1) Mail merged letters from “practice” 2) Data source for “practice” letters. 3) Excel data source 4) Merged labels 5) Merged envelopes * Create personal data source in Excel. Column A Courtesy title (Mr., Mrs., Ms., Dr., etc.) Column B First name Column C Middle name or initial (skip if none) Column D Last name Column E Greeting (How do you address this individual in person?) Column F Street address (number and street) Column G City Column H State (Use two-letter state abbreviation) Column I ZIP (5 or ZIP+4) Column J Home area code Column K Home telephone Name: Description: ...
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4