To see what mail merge does, select the Merge to New Document button on the toolbar. If I can be of assistance please call me. 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 > in my > period > class. The words will not show up in Word as purple, I did that for emphasis. Do the same in each place where you see text surrounded by the less than and greater than signs. I put a space at the end of the word of and selected Insert Merge Field from the Mail Merge toolbar. Many buttons are gray because no field has been inserted into the letter yet. Notice that a new toolbar, Mail Merge, has been placed with the toolbars above your document. Making that selection brings you back to a blank Word document. In other words, you will Edit Main Document. Of course there are no merge fields there.
Recall that we started with a blank document. The worksheet opens in the background, and Word asks you to make one more selection. Making that selection will open the worksheet Step 15. The only choice here is Entire Spreadsheet. After selecting the worksheet Word asks you to make a selection. Open the worksheet that contains the data needed for this form letter.
You have already created the data source, so choose Open Data Source from the drop down dialog box. The Mail Merge Helper box appears with choice 2 available now that you have made a selection. Click on the Create button and choose Form Letter from the drop down dialog box. As you make selections in this box other selections will become available. Go to the Tools menu and select Mail Merge. You may start the mail merge process before typing anything. It is not necessary to begin typing the form letter. If a new blank document does not automatically open, go to the File menu and select New. Create your own or copy what you see below: Step 6. When your cursor turns into a double headed arrow, click and drag to the right. Place the cursor on the light gray line between and two of the highlighted headings. Place your cursor over the " A" in the column heading and drag to the right unto you reach the " E" column heading. Your worksheet will probably look somewhat like the one you see below: Step 3.
Do not worry if the cell is not wide enough. Press the Tab key to move to cell B1 and type "Last name." Continue until each of the field names above have been entered. Field names must be entered in the cells across row 1. For this activity we will use the following field names: The field names you choose will be determined by the form letter you want to produce.
Can i do a mail merge excel to excel zip#
Common field names are First Name, Last Name, Telephone, and zip code. A database has field names for each type of information entered. The excel worksheet will take the place of a database. Preparing a form letter with Word and Excel The first step is to prepare the data source from which information will be inserted into the form letter. Using Word and Excel to Produce a Form Letter
0 kommentar(er)
