Microsoft Word:
Mail Merge
Mail merge is an operation performed within
a word processor in order to combine generic information and layout in
the word processing document with specific data that is stored in another
document, usually a table, spreadsheet, or database. Mail merge can be
used for a variety of situations, including:
Step 1: Set up your document
(OPEN A BLANK DOCUMENT)
Under Main document, click
Create then MailingLabels.
Click Active Window.
Step 2: Getting the data source
In the Data Source section,
click on Get Data.
Select Set Up Main Document.
Select the label type.
If you don't see the Label Options dialog box, click anywhere
in the main document, and then click MailMerge
under the Tools menu.
Under Main document, click
Setup. Select the type of printer and labels you want to
use, and then click OK.
In the Create Labels dialog
box, insert merge fields where you want to merge addresses from
the data source.
To insert a merge field, click
Insert Merge Field, and then click the field name you want.
Click OK.
Mail Example Merge 2: Create Form Letter Step 1: Set up your document
Under Maindocument, click
Create then Form Letters.
Click Active Window
Step 2: Getting the data source
In the Data Source section,
click on GetData.
Change the Files of Type
drop down to MS Excel Worksheets (.xls).
Select the Excel spreadsheet
that you are using.
On the Microsoft Excel dialogue
box select EntireSpreadsheet. Click OK.
Edit the maindocument and insert merge fields.
Insert merge fields where you
want to merge names, addresses, and other data from the data
source. To insert a merge field, click in the main document
then Insert Merge Field on the
Mail Merge toolbar, and then click the field name you want.
