CSCI 1100 Word Project II

Mail Merge

For the second Word project, you will produce a simple form letter that takes name and address entries from an Excel spreadsheet to produce a form letter with the following requirements:

• Create a folder in your P:\web\cs1100\ folder called "word2" that will hold your Excel file and two Word documents.
• Create an Excel spreadsheet with columns for FirstName, Middle, LastName, Title, Suffix, Street Address, City, State, and ZIP.
• Enter at least 10 names and addresses into your spreadsheet.
• Use Word to produce a Mail Merge form letter that contains
  • the date
  • the address block
  • a customized greeting (salutation)
  • at least two customizations (name, city, etc.) in the text of the document
  • a closing with your name (Sincerely, Yours truly, etc.)
• Merge the letter to a new document, and save both documents to your word2 folder, along with the excel file
• Link to all three files from your CS1100 web page

Due online Wednesday, October 12, by the beginning of class.