Using mail merge in
Microsoft Word 2003
Created: 12 April 2005
Mail Merge
Note: You should be competent in Microsoft Word before you attempt this Tutorial.
Open Microsoft Word 2003
Beginning the Merge
You may start Mail Merge with a blank document or one that you have already created.
We will use a blank document in this tutorial.
To begin the Mail Merge sequence click Tools in the Menu Bar, select Letters and Mailings, and then Mail Merge Wizard (see arrows below).
You will now see a Microsoft Mail Merge task pane appear on the right side of your screen – similar to the image at the right.
We will begin this tutorial by creating a mail merge letter. When we have completed the letter we’ll discuss Envelopes, Labels, and E-mail messages.
Notice that the small circle to the left of Letters has a dot in it. This is the default selection. We’ll use letters to begin.
You’ll notice, at the bottom of the Task Pane that it looks like the image on the right. Now that we’ve selected Letters, we can proceed to the next step in the Wizard. Click Next: Starting document.
We are leaving Step 1 of the Mail Merge Wizard and moving to Step 2.
The top of the Step 2 Task Pane looks like the image on the right. We indicated earlier that we are going to use a blank document for this tutorial. So, we’ll remain with the default selection – Use the current document.
The Essay on Electronic mail will out perform the regular Postal Service
New technologies have always allowed us to do things faster, more efficiently and more professionally than ever before. Generally, every new technology is a step forward for speed and productivity. The speed, usage, reliability, and expense make electronic mail more desirable than our general postal system. The speed of transfer is an important part of the decision to send mail by either E-Mail or ...
At the bottom of the Step 2 of 6 Task Pane, click Next: Select recipients.
Notice, in the image on the right that, as you proceed through the Mail Merge Task Panes, you can go back and forth at any time you desire. This is logical and handy.
Selecting your merge file (Access, Excel, Word, Outlook)
You are now in Task Pane 3. In this task pane you will select the source list for your mail merge. We’ll be using an Access database for this tutorial. You can use an Excel spreadsheet, Outlook Mail Contacts, or several other sources.
The Access database file we will be using was created with our Access 2003 tutorial. If you’d like a copy of this tutorial and database file, please e-mail the address found at the end of the tutorial, or download them from our website, which is also found on the last page.
Click the Browse button in Task Pane 3.
We, as indicated, are going to select an Access Database. It is located on our C: drive in the Folder Mail Merge Word XP.
After we select our database we’ll click the Open button.
You may choose several other file types, as previously indicated. If you click the small down arrow to the right of the Files of type: area in the Select Data Source menu screen (image at bottom of last page and on right), you will see many other file types from which you can merge.
When we selected the Person 2003 database, the following Select Table menu appeared. This database contains three Tables – we are going to choose the Personnel Table.
After we selected Personnel, we clicked the OK button. The Mail Merge Recipients menu screen appears.
Spend a few moments viewing Mail Merge Recipients screen (at the bottom of the last page).
Use the elevator bars at the bottom and on the right of the screen to view your data.
If you are not familiar with the Mail Merge Recipients Filter Screen, an addendum on how to use this filter screen is provided at the end of this tutorial on Page 30.
The Essay on What’s a Mail Merge?
Mail merge is the process of integrating the raw data from a list (e.g. a list of individuals with tax liens), with a standard letter, so the end result is one custom letter per client, containing that particular client’s individual information from that list. There are many benefits in doing a mail merge, such as: •Each client receives a custom letter with their name, address, and other ...
Click the OK button when you have viewed the screen to your satisfaction.
Look at the middle of Task Pane 3 again. Notice that the Browse selection has been replaced by the image to the right. This Task Pane now indicates the database (or other source) you selected and allows you to edit the list which appeared when you made this selection (bottom of last page).
You are now ready to begin inserting fields into your mail merge document. However it would be prudent to save your mail merge letter at this time. Once you’ve accessed your database, the save feature will not only save your document, but preserve the link to your data source (database, spreadsheet, etc.)
Saving your Mail Merge document
You will want to save your mail merge documents periodically. Use your favorite Save method. We’ll click File in the Menu Bar and select Save (as shown in the image on the right.
The Save As menu screen will appear (image at the top of the next page).
We will save our document as Mail Merge Letter in the Mail Merge Word 2003 Folder on our C: drive.
Creating the Mail Merge Document
Having selected our data source, we are now ready to create our mail merge document. Look at the bottom of the Step 3 of 6 Task Pane and click Next: Write your letter.
You will now be taken to the Mail Merge Step 4 of 6 Task Pane. The top of this Task Pane looks like the image on the left.
We’ll cover two of the selections you see at the left – Address block and More items. Greeting line is similar to Address block.
If the cursor is not visible at the top of your document, click the top left corner of your document.
We’ll begin our letter with the Address Block.
Click the Address Block selection (as indicated at the bottom of the last page).
The following Insert Address Block menu screen will appear. If you accept the default setting screen, as shown in the image on the right, it will search your database and attempt to create an address similar to the one shown in the Preview area.
If you have fields that are different, or in addition to those shown, you can click the Match Fields button.
The Term Paper on Mail Merge
... to insert individual merge fields. When you click More Items, the Insert Merge Field dialog box appears. In the Insert Merge Field dialog box, click the merge field that ... a merged document on screen; and you can also “preview” the mail merge without actually merging (using the View Merged Data ... reorder the merge fields. 5. In the New Address List dialog box, click OK. In the Save Address List dialog ...
Examples of how to use the Match Fields menu screen are furnished at the top of the next page.
Look at the right side of the Match Fields menu screen. Notice that Mail Merge had no problem matching Last Name and First Name – since these are the same as our field names. However, also note that it selected our Street Address to Match Address 1 and our Zip to match Postal Code.
If you desire to change a match, simply choose one of the fields under Required Information or Optional Information and click the down arrow on the box to the right. We chose Last Name. When we clicked the arrow fields and our database fields appeared on the right. To replace a field, simply click on your field on the right.
If you change any fields, click the OK button and they will be replaced. You will return to the Insert Address Block menu screen.
We’ll use the default Address (that you see on the right).
You choose the one you desire and then click OK.
The upper left corner of your document should look like the image on the right.
Tap the Enter key a couple of times to make sure your cursor is below the . Your document and cursor should look similar to the one on the right.
Now that we’ve inserted an Address Block, we’ll use the More Items selection to show you another way to do this.
You will then be able to compare the two methods and select the one you like best.
Click the More items… selection. The Insert Merge Field Menu Screen at the right will appear.
In the Insert Merge Field Menu screen, click the First Name selection, then click the Insert button at the bottom of the screen (see image and arrows on the right), then click the Close button.
When you do, the text will appear below the text.
Click the More items… button in the Mail Merge Task Pan on the right again.
When the Insert Merge Field Menu Screen appears, click the following: (when you click a field name, click the Insert button after each selection):
Last Name (Insert), Street Address (Insert), City (Insert), State (Insert), Zip (Insert) – and now click the Close button. Your screen should now look like the text at the top of the next page.
Don’t worry about this. Since you are already an accomplished Word user, we’ll now arrange this text to look like a normal mailing address.
The Term Paper on Oil Field Desander Screen Installation and Maintenance
Desander is the second-stage drilling mud solids control equipment, which is widely used in all oil fields all over the world. It plays an import role in the solids control system, which has a variety of devices, including shale shaker, mud cleaner, vacuum degasser, decanter centrifuge, as well as several other auxiliary units. In oil field drilling mud management area, desander of KOSUN is a ...
Move your cursor between the First_Name>> and