How to Apply Mail Merge - NYIM Training Blog

How to Apply Mail Merge Posted on May 20, 2014 by Joe Tandle Like 1

How to Apply Mail Merge When you are performing a Mail Merge, you will need a Word document (you can start with an existing one or create a new one) and a recipient list, which is typically an Excel workbook. If you’d like to work along with the lesson, you can download the examples below. Letter (Word document) Recipient list (Excel workbook)

To use Mail Merge: 1. Open an existing Word document, or create a new one. 2. Click the Mailings tab. 3. Click the Start Mail Merge command. 4. Select Step by Step Mail Merge Wizard.

The Mail Merge task pane appears and will guide you through the six main steps to complete a merge. The following is an example of how to create a form letter and merge the letter with a recipient list. Step 1: 1. Choose the type of document you wish to create. In this example, select Letters.

2. Click Next: Starting document to move to Step 2. Step 2: 1. Select Use the current document.

2. Click Next: Select recipients to move to Step 3. Step 3: Now you’ll need an address list so Word can automatically place each address into the document. The list can be in an existing file, such as an Excel workbook, or you can type a new address list from within the Mail Merge Wizard. 1. From the Mail Merge task pane, select Use an existing list, then click Browse.

2. Locate your file in the dialog box (you may have to navigate to a different folder), then click Open.

3. If the address list is in an Excel workbook, select the worksheet that contains the list, then click OK.

4. In the Mail Merge Recipients dialog box, you can check or uncheck each recipient to control which ones are used in the merge. When you’re done, click OK to close the dialog box.

5. From the Mail Merge task pane, click Next: Write your letter to move to Step 4. If you don’t have an existing address list, you can click the Type a new list button and click Create. You can then type your address list. Step 4: Now you’re ready to write your letter. When it’s printed, each copy of the letter will basically be the same, except the recipient data (such as the name and address) will be different on each one. You’ll need to add placeholders for the recipient data so Mail Merge knows exactly where to add the data. If you’re using Mail Merge with an existing letter, make sure the file is open. To insert recipient data: 1. Place the insertion point in the document where you wish the information to appear. 2. Select Address block, Greeting line, Electronic postage, or More items from the task pane.

3. Depending on your selection, a dialog box may appear with various options. Select the desired options, then click OK.

4. A placeholder appears in your document. For example: «AddressBlock». 5. Repeat these steps each time you need to enter information from your data record. 6. From the Mail Merge task pane, click Next: Preview your letters to move to Step 5. For some letters, you’ll only need to add an Address block and Greeting line. Sometimes, however, you may wish to place recipient data within the body of the letter to personalize it even further. Step 5: 1. Preview the letters to make sure information from the recipient list appears correctly in the letter. You can use the left and right scroll arrows to view each document.

2. Click Next: Complete the merge to move to Step 6. Step 6: 1. Click Print to print the letters.

2. The Merge to Printer dialog box opens. Click All, then click OK.

3. The Print dialog box will appear. Adjust the print settings if needed, then click OK.


1. Open an existing Word document. If you want, you can use this example. 2. Download this recipient list. 3. Use the Mail Merge Wizard to merge the letter with the recipient list. 4. Place an Address Block at the top of the page and a Greeting line above the body of the letter. 5. Print the document. Credit:

S H A R E TH IS : More

LIK E TH IS : Loading...

This is somewhat embarrassing, isn’t it? It seems we can’t find what you’re looking for. Perhaps searching, or one of the links below, can help.





Special Promo – Save 25% Off Your

Excel Training (137)

Try looking in the monthly archives.

Next MS Office Class!

Outlook Training (55)

NYIM – The Most Practical Computer

General (54)

Training in New York City!

PowerPoint Training (39)

Make a Resolution to Get Smarter This

Word Training (34)


Mac (28)

15% off all WordPress Web Design

Excel (26)


Photoshop Training (25)

Save $100! Now $649-Photoshop

QuickBooks Training (25)

Essentials 2 Day Course (Regularly

Illustrator Training (18)

Archives Select Month

$749) $50 Off Advanced PowerPoint for Mac Training! (Reg Price $199) QuickBooks for Mac 11/21/16 Training $50 Off! Virtual Reality Training at NYIM – Best VR Training in NYC! $199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Regularly $299 each) People With Excel Skills Earn More Money!


"The specified file is not a valid spreadsheet or contains no data to import" Error When Importing an Excel Spreadsheet into SharePoint 2010 A Chart Showing where everything in Outlook 2003 is now in Outlook 2010- Free XLS Batch Processing in Photoshop CS5 CC or BCC" Field? Answer Comparison of What Office 2011 for Mac can do and can't do with Sharepoint 2010 Copy all Calendar Items to another Calendar Outlook 2010 embed You Tube Every Photoshop CS5.1 Shortcut in PDF Excel 2010 Macro to Do something to a Dynamic Range Excel SUMIF/COUNTIF contains text Excel Vlookup Tutorials at NYIM Training Free Excel 2010 Multiple Choice Test

How do I set Outlooks

Calendar to Military Time (24 hour clock) (Outlook 2010 Training) How to Create Histograms in SPSS How to Force a Page Break in Excel

How to show hidden files in Mac OS X Lion

How to

Update your Job Status in Quickbooks How to Use Slicers in Excel

Import Excel Spreadsheet to a SharePoint 2010 Custom List Importing a Powerpoint file into InDesign

InDesign CS5.5 Shortcut Sheet- Free Linked In and Facebook Social Connector with Outlook 2010 (What does it really do?) Macro to close the current worbook without saving and reopen the same workbook move all items and add categories New Features of PowerPoint 2010 Outlook 2010 Automatic Meeting Responses Outlook 2010 Solution: This meeting is not in the calendar- it may have been moved Perfect 3 Column Liquid Layout with CSS Photoshop CS5.1 Shortcut Sheet

Photoshop Training PowerPoint


2010 VBA Code to add an audio File or Video File PowerPoint 2010 VBA Macros PowerPoint 2010 VBA to add a video PowerPoint 2010- New Features you probably don't know about SharePoint 2010 Live Online and Classroom Training Outline SharePoint Permissions Overview SPSS 20 New Features Video Training Class Courses SPSS Basics (IBM Statistics) Free Training Class Videos Twitter inside of PowerPoint 2010 VBA Macro to Take all Overflow PowerPoint Text and move to a new slide Video Tutorial to add Another Outlook 2010 Shared Calendar Welcome Message Why Does Outlook underline email addresses in the "To Word 2010 Find and Replace Wildcard Reference

This entry was posted in Word Training and tagged How to Apply Mail Merge by Joe Tandle. Bookmark the permalink [] .


How to Apply Mail Merge - NYIM Training Blog

How to Apply Mail Merge Posted on May 20, 2014 by Joe Tandle Like 1 How to Apply Mail Merge When you are performing a Mail Merge, you will need a Wor...

686KB Sizes 2 Downloads 15 Views

Recommend Documents

No documents