Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

  1. Enter the 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. From the dropdown list, choose <<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.
  • No labels