Mail Merge with Word and Excel - Internet4Classrooms


Sign Up For Our Newsletter Email:


Subscribe | Newsletter Index | Daily Dose | About | Site Map Home | SAT/ACT

| Common Core | Online Practice | Printables | Grade Level Help

| Links PreK-12 | Tech | Assessment


Mail Merge with Word and Excel

Follow @internet4classr



Home > Technology Tutorials > Word Tutorials > Form Letter advertisement

Home Technology Tutorials Microsoft Office Word Tutorials Form Letter

Using Mail Merge Preparing a form letter with Word and Excel Two Microsoft Office applications will be required for this task. Excel will be used for the data and Word will be used to create the form letter. A form letter is one in which the body of the letter stays the same but specific information is inserted for/about several different individuals. You have probably gotten one like that in the past. The first step will be to prepare the data source from which information will be inserted into the form letter. Step 1. Open Microsoft Excel. Remember to leave your browser window open until this lesson is finished. The excel worksheet will take the place of a database. A database has field names for each type of information entered. Common field names are First Name, Last Name, Telephone, and zip code. The field names you choose will be determined by the form letter you want to produce. For this activity we will use the following field names: First name


Last name Subject Class period Average grade Step 2. Field names must be entered in the cells across row 1. Type "First name" in cell A1. Press the Tab key to move to cell B1 and type "Last name." Continue until each of the field names above have been entered. Do not worry if the cell is not wide enough. Your worksheet will probably look somewhat like the one you see below:

Step 3. Place your cursor over the " A " in the column heading and drag to the right unto you reach the " E " column heading. All five columns will be highlighted. Step 4. Place the cursor on the light gray line between any two of the highlighted headings, and double-click. All columns will adjust in width to fit the data. Step 5. Enter four lines of data. Create your own or copy what you see below:

Step 6. Save the worksheet. Remember where you saved it. I recommend saving to the desktop. Close the worksheet. Step 7. Open Word. If a new blank document does not automatically open, go to the File menu and select New . Then open a new blank document Step 8. It is not necessary to begin typing the form letter. You may start the mail merge process before typing anything. Step 9. Go to the Tools menu and select Mail Merge . The Mail Merge Helper dialog box opens. As you make selections in this box other selections will become available. advertisement

Step 10. Click on the Create button and choose Form Letter from the drop down dialog box. That brings up the following dialog box. Select Active Window.

Step 11. The Mail Merge Helper box appears with choice 2 available now that you have made a selection. Select Get Data .

Step 12. You have already created the data source, so choose Open Data Source from the drop down dialog box. Step 13. An Open Data Source dialog box will open and you must do two things. 1. Navigate to the place where you saved the Excel worksheet. You will not see your saved worksheet yet. 2. Change the Files of type: box by clicking on the down arrow and scrolling down to MS Excel Worksheets

Step 14. Open the worksheet that contains the data needed for this form letter. After selecting the worksheet Word asks you to make a selection. The only choice here is Entire Spreadsheet . Select OK . Making that selection will open the worksheet

Step 15. The worksheet opens in the background, and Word asks you to make one more selection. Recall that we started with a blank document. Of course there are no merge fields there. It is time to produce the letter. In other words, you will Edit Main Document.

Step 16. Making that selection brings you back to a blank Word document. Notice that a new toolbar, Mail Merge, has been placed with the toolbars above your document. Many buttons are gray because no field has been inserted into the letter yet.

Step 17. Type the following letter. In the first line, I did not type

. I put a space at the end of the word of and selected

Insert Merge Field from the Mail Merge toolbar. Do the same in each place where you see text surrounded by the less than and greater than signs. The words will not show up in Word as purple, I did that for emphasis. To the parents of


As we approach the end of the first six weeks I wanted to let you know how glad I am to have period

class. At this time

in my

's average is


If I can be of assistance please call me. Step 18. To see what mail merge does, select the Merge to New Document button on the toolbar.

Step 19. Since we entered four names in the worksheet, four letters will be produced. At the bottom right corner of the Word window you will find up and down arrows that allow you to move to from one letter to another. Possible uses - Any letter or document that needs to be sent to multiple recipients is a good candidate for a mail merge. Some obvious uses include: Note to parents Progress report Certificates Go back to Using Microsoft Word to Produce Classroom Documents

Search Internet4Classrooms Search I4C Website Custom Search

Internet4classrooms is a collaborative effort by Susan Brooks and Bill Byles.

Home | SAT/ACT | Common Core | Online Practice | Printables | Grade Level Help | Links PreK-12 | Technology Skills | Assessment Site Map | About Us | Teacher Training | Make your home page. | Copyright © 2000-2017 Internet4Classrooms, LLC All rights reserved. Use of this Web site constitutes acceptance of our Terms of Service and Privacy Policy.

248057843 US 1 desktop not tablet not iPad device-width


Mail Merge with Word and Excel - Internet4Classrooms

Sign Up For Our Newsletter Email: Go Subscribe | Newsletter Index | Daily Dose | About | Site Map Home | SAT/ACT | Common Core | Online Practice ...

404KB Sizes 2 Downloads 17 Views

Recommend Documents

Using Mail Merge - Internet4Classrooms
You may start the mail merge process using the wizard. Go to the Mailings tab, go to the Start Mail Merge section, click

26 Sep 2014 - Step 3: Now you will need an address list so Word can automatically place each address into the document.

Word 2002: Mail Merge
Records 5 - 10 - winner of $10 Million Dollars!! Performing a mail merge isn't a very difficult process, but it is a rat

Mail Merge in Word
Dec 3, 2007 - Merge (Tools/Letters and Mailings/Mailmerge), a Task Pane appears to the right of the document and is visi

Mail Merge Toolkit: mail merge in Outlook, Word and Publisher
With Mail Merge Toolkit add-in, you can merge fields from different data bases, incl. Excel data files: all the opportun

Sensing mail with mail merge
This manual shows you step by step how to do this, and how to make a selection in a list of recipients so that your e-ma

Microsoft Word Mail Merge -
It will then be used to create a form letter and labels for each name in the data file. Create a Data File in Excel · Cr

Word 2010 Mail Merge - AddictiveTips
Mar 5, 2010 - Launch Word 2010, navigate to Mailings tab, and from Start Mail Merge options, click Step by Step Mail Mer

Mail Merge (Microsoft Word) - Word Tips - Tips.Net
Word has a Mail Merge manager that makes putting individualized data into your document easy. The following articles exp

Word: Mailing Lists and Mail Merge - WebLearn
Feb 1, 2013 - Word: Mailing lists and Mail Merge. IT Learning Programme. 3. 3 Step by step instructions. We are going to