• Full name and address
• First name
• Donated item
• Value
• Number of tickets requested STEP 1 : Import Text File Into a Spreadsheet and Clean up Data A . Download the text file : Week4 _ iLab _ MailingData _ Student . txt . To complete the download , right click on the file name and select Save Link As . The file will save to your local drive . B . Open a new Excel file and import only the data from the txt file you will need for your letter ( i . e ., excluding unnecessary columns ). C . Separate the first and last names into two columns so that you may use the first name in a Mail Merge . Make sure the fields are named LastName and FirstName . D . Check the accuracy of all data by using the Spelling tool in the Proofing group . E . Add a documentation sheet that provides a spreadsheet title , author , date , and purpose . Format the documentation sheet by applying a professional color scheme to the text . Ensure that the sheet tab is named Documentation and that the documentation sheet is the first sheet in the workbook . STEP 2 : Create Merge Document A . Open the Week4 _ iLab _ Trust _ Template _ Student . docx document in Word . Make sure that the document is in the same folder as the Excel spreadsheet . This will make it easier to work with the two documents during the Merge process .
• Note : Be sure to name this file , using the naming conventions listed above . B . Merge information from your Excel spreadsheet into the Word document . Your completed merge will look like the following when complete . 9 / 27 / 2015 Student Education Trust 123 Adams Street Pittsburgh , PA 15697