BIS 155 Endless Education /uophelp.com BIS 155 Endless Education /uophelp.com | Page 41

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