Just letting you know that if you do want to use textjoin, it’s only available from excel 2016 and higher! I love textjoin, I have a macro specifically for it From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Brad Hubley Sent: Tuesday, May 08, 2018 8:22 PM To: [log in to unmask] Subject: Re: adding object to an object package Hi Rodger; I did this very thing today for the first time with 1,444 object numbers in Excel. You need to use the textjoin function in Excel to put all of the numbers into one cell with each number separated by a comma. In my case, I had my object numbers in column A from row 1-1444. In cell B1 I entered = textjoin(",", True, A1:A1444). Then I copied the contents of B1 and Pasted Special as Value into cell B2 in Excel. Then I copied and pasted the contents of B2 into a Query Assistant while searching for Object Number. Let me know if you need more detailed instructions. Brad Hubley Royal Ontario Museum Department of Natural History - Entomology Toronto ON Canada On May 8, 2018, at 6:06 PM, Kelly, Rodger S <[log in to unmask]<mailto:[log in to unmask]>> wrote: Colleagues, Is there a way to create an object package based on a list of numbers in Excel or Word? We often have lists of objects we want to move, create new thumbnails for, etc. It would be so helpful if we could paste a list of number into the object package. If this isn’t doable I hope it will be considered for development. Thanks, Rodger RODGER KELLY Deputy Director of Operations / TMS (The Museum System) Administrator National Music Museum University of South Dakota 414 E. Clark St., Vermillion SD 57069 http://nmmusd.org<https://urldefense.proofpoint.com/v2/url?u=http-3A__nmmusd.org_&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=jgbbXtz53zbaPWUmbVmB-QsFYiW_YyIzVFhhrvn6iRU&e=> [log in to unmask]<mailto:[log in to unmask]> (605) 677-5306 <image001.png><https://urldefense.proofpoint.com/v2/url?u=http-3A__www.nmmusd.org_&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=tPnxp7YWXIdPJnsy7zEsPkudRgojbZIg8_d3uKoCPsc&e=> <image002.gif><https://urldefense.proofpoint.com/v2/url?u=https-3A__www.facebook.com_NationalMusicMuseumUSA&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=5L_3tl1M3qd63Ub3cbsZ2_wJMIkuDtB3xfOvtsGvy-g&e=><image003.gif><https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_NMMUSD&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=wqq_AJGf1ABvYl3As5j8IsjORhP_3wTYfoXuifLMEcA&e=><image004.gif><https://urldefense.proofpoint.com/v2/url?u=http-3A__www.youtube.com_NMMUSD&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=ZXmBlnC_5o5ful1rNZC_u2kpdxvzBWLqeoJFkfNTDkc&e=><image005.gif><https://urldefense.proofpoint.com/v2/url?u=http-3A__www.pinterest.com_NMMUSD&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=xDb0doSJSavmp97rtr6Tmo18kuSKYp1hlzx_WpaKxU8&e=> To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. ON NOW Evidence Room<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.rom.on.ca_evidence&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=YD-zcXOuZWmvLDZc6C6VFDtcAM18JtZ2iQR12CtTGm0&e=> COMING SOON 2 June | Iris van Herpen: Transforming Fashion<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=mzgDkb2tDo4-zccojlVZDwIeihoJKoczzfOFPtfYxgk&e=> 2 June | Philip Beesley: Transforming Space<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=mzgDkb2tDo4-zccojlVZDwIeihoJKoczzfOFPtfYxgk&e=> 16 June | Spiders: Fear & Fascination<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.rom.on.ca_en_exhibitions-2Dgalleries_exhibitions_spiders&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=vt7YEvG9_y4aYjMh-j73g1vBwWIBCpe8SyappTJG2to&e=> ________________________________ À L’AFFICHE La Chambre des preuves<https://urldefense.proofpoint.com/v2/url?u=https-3A__rom.on.ca_fr_chambre-2Ddes-2Dpreuves&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=jrV1hm_xzqr3cvUMPgHGq7SnmX2fWTrmfUojBFMrtz8&e=> À VENIR 2 juin | Iris van Herpen : Transformer la mode<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_fr_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=WBx3D1drNFMKM-BXTqvBxNVFdciKPR_OFlaukYdJGVc&e=> 2 juin | Philip Beesley : Transformer l’espace<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.rom.on.ca_fr_iris&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=WBx3D1drNFMKM-BXTqvBxNVFdciKPR_OFlaukYdJGVc&e=> 16 juin | Les araignées : Peur et fascination<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.rom.on.ca_fr_expositions-2Det-2Dgaleries_expositions_les-2Daraignees-2Dpeur-2Det-2Dfascination&d=DwMGaQ&c=WO-RGvefibhHBZq3fL85hQ&r=MSIcJJEi1Q7yXGOMVTgbBBb0spa1mr0BTnbzQUa8ybI&m=GzPywDwwJsBtodXFTT3n5nLVa_RX3gvYiH14F02OpPE&s=gIN2ArBWr0K3fH1JWe2ZHy5APvQ7s8XuLJEsGwlwThY&e=> To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.
