Mailmerge to Create Labels using Address file from Outlook Express
Open a New document in Word. On the Tools menu, click Mail Merge.
The Mail Merge Helper dialog box appears.
Step 1. Main document, click Create, and then click Mailing Labels and then Click Active Window.
The active document becomes the Mail Merge main document.
Word returns to the Mail Merge Helper.
Step 2: Data Source
The data source contains the information that can vary in each label. You can open an existing data source created in Word or use a file exported from Outlook Express Address Book (See Notes)
Select Open an Existing Data Source
a. In the Mail Merge Helper dialog box, click Get Data.
b. Click Open Data Source.
c. In the list of files in the Open Data Source dialog box, select the data source that you want to use, and then click Open.
If the data source that you want is not in the list of files, click the appropriate drive and folder. Select the appropriate option in the List files of type box.
Word displays a message to set up the main document.
Click Set Up Main Document.
Step 3: Edit Main Document
From the Tools menu - Select Labels
Word displays the Label Options dialog box. Click the type of printer , the type of label product (such as Avery), and product number. If you are using a custom label, click Details, and then type the size of the label. Click OK.
Word displays the Create Label dialog box. The insertion point is blinking in the box under Sample Label. This is where you insert the merge fields to represent where on the label Word should print the information from the data source.
Click Insert Merge Field in the Create Label dialog box. Click the appropriate merge field.
Make sure that you type any spaces or punctuation that you want between two merge fields or after a merge field.
When you have finished placing the merge fields on the sample label, click OK.
This step returns the focus to the Mail Merge Helper.
Step 4: Perform the Merge
1. Under 3. Merge the data with the document, click Merge.
Word displays the Merge dialog box. (If you click the Query option instead of Merge, you have the option to select certain data records to participate in the merge or to sort the records in the data source.)
2. Under Merge to, click New Document to display the merged document on the screen. This allows you to view the labels before printing them.
It is at this stage that you can format your text to be centred in each label.
Place the cursor in the first label and from the Manu - Table-Select-Column now select the Centre icon. Complete this operation for each column
(Select Printer to send the labels directly to the printer.)
3. With New Document selected in Merge to, click Merge.
After the merged document appears on the screen, you can save it as a separate document, or you can print the merged document by clicking Print on the File menu, or you can do both.
3. With New Document selected in Merge to, click Merge.
After the merged document appears on the screen, you can save it as a separate document, or you can print the merged document by clicking Print on the File menu, or you can do both.
Query Options will allow you to selectively merge the data. Look at the options and experiment
