If your object numbers include spaces or commas, then you might want to
wrap them in quotations.

Remember to use the OR option in Query Assistant (which is usually the
default)  otherwise your search will fail.

On Wed, May 9, 2018, 9:14 AM Im, Caroline <[log in to unmask]> wrote:

> 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]> 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]
>
> (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] 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] 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.
>

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.