170 likes | 320 Views
Separation Sheets Using A Mail Merge. Alison Starkey Alaska Regional Curatorial Center (ARCC) Annual Meeting 2013. Separation Anxiety. themodernl.blogspot.com. Archival Separation Solution. Word Template. Excel Spreadsheet. +. =. Merged Separation Sheet. Processing Goals.
E N D
Separation SheetsUsing A Mail Merge Alison Starkey Alaska Regional Curatorial Center (ARCC) Annual Meeting 2013
Separation Anxiety themodernl.blogspot.com
Archival Separation Solution Word Template Excel Spreadsheet + = Merged Separation Sheet
Processing Goals Reduce Unnecessary Steps Handwritten separations sheets are a waste of time.
Processing Goals Eliminate Mistakes Handwritten separation sheets are prone to errors.
Processing Goals Provide Legible Information Not everyone has neat handwriting.
Processing Goals Keep Information Together The elements for each separation sheet reside on one row of the spreadsheet, right next to the original folder information.
How to Do the Merge Perfect the Template
How to Do the Merge Insert the Merge Fields
How to Do the Merge Completed Template
How to Do the Merge Selecting the Table
How to Do the Merge Selecting Recipients
How to Do the Merge Preview
How to Do the Merge Complete the Merge and Print
Consideratons • Print out and place with each processed series or subseries or wait until the end of the project? • Provide box and folder numbers in ink or leave them blank? • Advantages for electronically generated separation sheets?
Consideratons • Print out and place with each processed series or subseries or wait until the end of the project? • Provide box and folder numbers in ink or leave them blank? • Advantages for electronically generated separation sheets?
Separation Anxiety No More! http://roleofparent.blogspot.com