Mujtaba Lab Assignment of Ict

Lab Assignment
Information Communication Technology
Student Name: Qazi Mujtaba Mehmood
Enrolment No: 01-235171-050
Class and Section: BSIT-(1-B)
TOPIC: How to Mail Merge through ‘MAILINGS’ option in MS WORD
Signatures of Lab Engineer: Submission Date: 02/03/2017
How to Mail Merge in Microsoft Word

Mail Merge is a powerful tool for writing and sending a personalized letter or e-mail to many
different people at the same time. You can also use it to create envelopes or labels with each
recipient' information. Mail Merge imports data from another source such as Excel and then
uses that data to replace placeholders throughout your message with the relevant information
for each individual you are messaging. You can use it to quickly create personalized messages
for hundreds of people at once.
1-To start a mail merge, open Microsoft Word 2007, and click on the Mailings tab.
2-Find the Start Mail Merge button under the Mailings tab and click the arrow
beside it. Choose the last option, Step by Step Mail Merge Wizard.
3-This brings up the task pane as shown below. Select Letters (or whatever type
you suits the job your working on) as the type of document and then click on
the Next: Starting document link at the bottom of the task pane to go to the next
step to select your starting document.
4- At this point you have options to use the current document you have open, to
select a template, or to browse to an existing document not open. For this
example we will start from a template. Select Start from a template. This brings
up a link you click on to Select template.
5-This will open the Select Template dialog box. Select the Letters tab and
choose Oriel Merge Letter. Click Ok. This will take you to the next step in the Mail
Merge process which you will select recipients.
6- Select Use an existing list and click on the Browse link. Locate and open the file
containing your data source. Your data source can be anything from a database
holding thousands of records to a simple spreadsheet that contain 10 names. For
this exercise I will use a existing test spreadsheet.
7-This will open a dialog box in which you can select the table (the named range
defined within Excel) containing the mail merge recipients info you want to pull into
the merge fields in your document. Select whatever you named the range in your
spreadsheet containing the names and addresses you want to use for the mail
merge ("attendees" is the defined range selected as shown below so I will use this
in my example).
8- Important: Be sure to check the box indicating that the First row of data
contains column headers so that the field labels (Last Name, First Name,
Address1, etc.) on your spreadsheet won’t be mistaken for data. This opens the Mail
Merge Recipients dialog box shown below. Here you can select which recipients to
include or deselect by unchecking the check box by the name.
9-You can sort and filter the list using the drop-down list located on each field name
indicated by the triangular black arrow. Note there are also links to Sort and Filter
or Find Duplicates and recipients in the Refine recipient list section. Click on the
link Next: Write your letter to move onto the next step to edit the mail merge
template letter content.
10-Notice that the Address Block and Greeting Line fields are already inserted into
this template letter. If you weren’t using a pre-formatted mail merge letter, you
would just simply click on the links on the right to insert the Address block,
Greeting line, or more items (more merge fields). You also have these same
options on the Mailings toolbar at the top.
11-Next, click on the link Edit individual letters which you can see from the screen
tip is the link to Merge to new document. This is also a button on the Finish &
Merge on the drop-down list on the Mailings Ribbon.
12-The Print link on the Task Pane or Print Documents on the Ribbon drop-down list
allows you to merge directly to the printer. When you click on the link to edit the
letters, the following dialog box appears:
13-You can choose whether to merge all or selected records. Click OK and then a
new merged document entitled Letters1 is created. It contains the individual
letters for each recipient. If you look at the status bar, you will see that it indicates
multiple letters. At this point you have completed a mail merge in Word 2007.
When finished you can always save this document you created for future
reference.

Mujtaba Lab Assignment of Ict

Uploaded by

Copyright:

Available Formats

Mujtaba Lab Assignment of Ict

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Mujtaba Lab Assignment of Ict

Uploaded by

Copyright:

Available Formats

Lab Assignment

Information Communication Technology

Student Name: Qazi Mujtaba Mehmood

Enrolment No: 01-235171-050

Class and Section: BSIT-(1-B)

TOPIC: How to Mail Merge through ‘MAILINGS’ option in MS WORD

Signatures of Lab Engineer: Submission Date: 02/03/2017

How to Mail Merge in Microsoft Word

You might also like