To do a Mail Merge using an Excel spreadsheet
To do a Mail Merge using an Excel spreadsheet –
Create the spreadsheet with the desired information, such as an address list. Make sure that you use the first row of the spreadsheet as a header row. Excel needs to identify each column by category.
[pic]
Rename sheet 1 at the bottom the page so that it will be easily identifiable. Save the spreadsheet and close it.
Open Microsoft Word.
Go to Tools_Letters and Mailings_Mail Merge. [pic]
This will open the Mail Merge task pane on the right side of the screen.
[pic]
In the Mail Merge task pane you have a choice of types of documents. The steps are at the bottom of the pane in hyperlink blue. To write a form letter from scratch, leave the radio button in front of Letters and choose Starting Document at the bottom of the pane.
[pic] [pic]
[pic]
Word will open the Excel file in the dialog box and list the sheets on the file. If you renamed the sheet it will be listed. If you did not, it will list the sheets in order. The first file will be listed as sheet 1. Select the sheet and click OK.
[pic]
The address list will appear in the dialog box. If it is the correct list, click OK.
Choose “Write your letter” at the bottom of the task pane.
[pic]
[pic]
Use a logical progression when typing the letter. Instead of typing the address on the letter, go to the spot where you would normally type the street address, click “more items” and choose street address from the list, click Insert and then Close. It will insert a marker to link the letter to the Street Address field in Excel. Use the space bar and Enter to manually set up the letter as you type and insert fields. For example, you would insert Street Address and then hit Enter to go to the next line. Insert City, close the card and then type a comma and space. Go back to more items and insert State. Close the card, hit space bar and then go back to more items to insert the zip code. The following illustration is a completed address.
[pic]
At any time you can go to the bottom of the task pane and “Preview your letters”. On that screen you can come back to the previous screen and continue working on the letter. When you finish and you have previewed the letters, you can Complete the Merge at the bottom of the task pane. When you do the task pane will have two choices in the middle: print and edit individual letters. Choose Edit individual letters and click OK. It will create the letters. These are the completed letters. Save this file and give it a name that will indicate that it is the finished product. Close the file – do not close Word. When you close the completed file the mail merge will still be on screen behind it. Save this file so that you will remember that it is the mail merge. If you open this file, you will be able to use the Mail Merge task pane to go back to the step where you chose the Excel file and you can choose a different file. You can then use that file to create more letters. You will have to make sure the column headings in the Excel files are the same.
-----------------------
This step allows you to choose whether you use this blank page to write the letter or to open an existing letter and insert the field names into it. If you choose to “Use the current document” you can type the letter and insert the fields as you go. If you choose to “Start from an existing document” you can open a document and insert the fields into the proper location.
The next step is to get the Excel file opened.
The blank letter will be on screen or the completed letter that you opened from your drive will be on screen. The task pane will have the five categories to choose from. If you are typing the letter you will type it as you normally would. When you get to a spot that you wish use to insert a field from the Excel file, choose “More items” and the column headings will appear. Click the correct field name and then click Insert and then Close.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- doing a mass printing of certificates and other documents
- to do a mail merge using an excel spreadsheet
- schedule of values instruction sheet
- excel assignment 1 mtsu
- microsoft excel spreadsheet
- overview of and how to use excel spreadsheets
- task 14 d1 discuss how organisations can use
- introduction to computing and excel
Related searches
- how to do a business
- how to do a resume
- how to do a full body cleanse
- how to do a financial analysis
- how to do a proper citation
- how to do a research paper
- how to do a self evaluation
- how to do a will
- how to do a marketing campaign
- how to do a spreadsheet in excel
- how to do a spreadsheet on computer
- how to do a spreadsheet in word