Copy and paste a list

You can copy a list to paste into another system, copy a list which opens in Excel, and you can paste a list into Vernon CMS.

Copy a list

With a list open in List Manager, go to the Edit menu and click Copy Table with Headings.

If you don't want to include headings, click Copy Table without Headings.

Copy a list to Excel

You can copy lists to Microsoft Excel. Vernon CMS will only copy the fields you have in List Manager, and the thumbnails for each record.

With the list open in List Manager, go to the Edit menu and click Copy to Excel with Images.

If you don't want the images, click Copy to Excel without Images.

Paste a list into List Manager

You can paste lists into List Manager from outside Vernon CMS if the records in the list have identifying information that exists in Vernon CMS. When you paste, Vernon will search for each record. So it's a good idea to have information that is unique to the record, like the accession number or System ID as part of the list.

With List Manager open, go to the Edit menu and click Paste. If there is more than one record that matches your data, Vernon will give you all options in the Authority window. You can select the records you want to include and then return to List Manager.

If you want the system to automatically select all the possible matches instead of asking you to choose, you can use paste the list ‘quietly’. With List Manager open, go to the Edit menu and click Paste List Quietly.