Digital Media Label Creation

Owned by Magee Lawhorn (Unlicensed)
Last updated: Oct 07, 2022 by Melanie Wisner
  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.

Alternate method using Microsoft Access

  1. With the Born-Digital Media Log open, navigate to H:\HOUGHTON\Technical Services\MS Section\MS documentation.
  2. Open the document named "HOU.labels.other". It should open in Access.
  3. Note in the left panel under "Tables" the item labeled "Digital media: paste into Shelf-number column".
  4. In the Media Log, copy the entire column labeled Item Number that contains the label content.
  5. In Access open the table labeled "Digital media: paste into Shelf-number column"; paste the column from the Media Log into the Shelf-number column.
  6. In Access under "Reports", open the report labeled "Digital media label". This should now display the data you just pasted.
  7. (If using the shared Ricoh printer: place a stack of 7-10 label sheets face-down in the side manual feed tray.)
  8. With the Digital media label report open, go to File > Print. Select the middle option simply labeled "Print" (not quick print, not print preview).
  9. In Printer Name, select the correct one from the drop down list ("Ricoh" for the shared printer in TS).
  10. Then select Properties: for Input Tray, select "Bypass Tray". Also select "1 sided" under One Click Preset List. Click OK.
  11. Select Print Range and enter "Pages from 1 to 1".