Mail Merge

  • Due No Due Date
  • Points 100
  • Submitting a text entry box or a file upload

Now used generically, the term "mail merge" is a process to create personalized letters and pre-addressed envelopes or mailing labels mass mailings from a form letter – a word processing document which contains fixed text, which will be the same in each output document, and variables, which act as placeholders that are replaced by text from the data source.

The data source is typically a spreadsheet or a database which has a field or column for each variable in the template. When the mail merge is run, the word processing system creates an output document for each row in the database, using the fixed text exactly as it appears in the template, but substituting the data variables in the template with the values from the matching columns.

Mail merging is done in following simple steps:

  • Creating a Main document.
  • Creating a Data Source.
  • Adding the merge fields into main document.
  • Merging the data with the main document.

Directions:

In this activity you will open the  Download Welcome Mail Merge.doc

fille and follow the directions to create a database, mailing labels, and merge a letter with the database.

Download Welcome Mail Merge.doc

Once you have completed your database with appropriate queries and reports, save your file in the appropriate place on the network.  You will then upload this information using the Submit Assignment button in the upper right hand corner of this window.  Be sure to proofread your work before you submit it.

0