B . Merge data from your Excel spreadsheet into the new label document .
Submit your completed workbook and the two Word documents ( merged letters and merged labels ) to the Dropbox . Make sure you post a comment about what you learned when submitting the files .
3 : Create Address Labels ( 15 points )
Create labels for the letters . The XYZ Corporation wishes to use mailing labels to address the envelopes . They own 8 1 / 2 x 11 " sheets of label paper with 1 " by 4 " labels , which they purchased from Office Depot .
Download the Lab 4 , Step 3 Instructions .
A . Create a new file for printing labels .
B . Merge data from your Excel spreadsheet into the new label document .
Submit your completed workbook and the two Word documents ( merged letters and merged labels ) to the Dropbox . Make sure you post a comment about what you learned when submitting the files .
Scenario / Summary
You work with the XYZ Corporation Charitable Trust allows you to demonstrate your expertise with Excel . The trust is sponsoring an auction , and you have received a list of all donors who have contributed to this auction . The list was pulled from the Corporation ' s database as a comma separated text file . You have been asked to create a letter that will go out to each of the contributors that will accept their donation . Tickets to the event will