Versions Compared

Old Version 5

changes.mady.by.user Monique Lassere

Saved on

compared with

New Version 6

changes.mady.by.user Monique Lassere

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Enter the evidence numbers Item Numbers into the Born-Digital Media Log.
  2. Download and export the log as an Excel spreadsheet.
  3. Open a Microsoft Word document.
  4. Go to Mailings.
  5. Go to Start Mail Merge, then click labels.
  6. Next select the label vendor as Avery US Letter, then choose Avery 6467 Removable ID labels.
  7. Click Select Recipients and select Use an Existing List….
  8. Choose to upload the media log Excel spreadsheet that you have previously downloaded and updated.
  9. Once open select the correct table/sheet. The media log has three sheets, choose the AccessionsLog$ sheet. And click ok.
  10. Go to Insert Merge Fields. Insert the <<Item Number>>, keeping the font and size the same but make the type bold.
  11. Underneath the <<Item Number>> add <<Label Field>> keeping the font and size the same.
  12. At this stage you may have to play around with the margins and/or line and paragraph spacing section.
  13. Hit Update Labels. Then click on Preview Results to see if your labels are correct.
  14. If your labels are correct then click Finish & Merge and select Print Document.
  15. Under Merge for Printer select Current Record.