That was my conclusion after roaming in the Exchange tools web sites yesterday night. Thank's for the ideas
-----Message d'origine----- De : Daniel Chenault [mailto:[EMAIL PROTECTED]] Envoyé : 3 octobre, 2002 20:18 À : Exchange Discussions Objet : Re: Distribution List Okay, that makes it a bit harder. Since the SMTP address is unique within the org you can use it as an index. You'll need to get fancy in Excel. Export the current list and do a matchup between the list you get from Oracle. Use the resulting matched info to create the list for import. Or... Create an access database. Have it programatically watch for the list from Oracle. At that point it does the export and than drags those into it's own database. It creates a subset of the database based on the Oracle input and writes that out as a CSV and than calls admin to import. This way you can practically automate the whole thing. There ain't no off-the-shelf solution. ----- Original Message ----- From: "Bourque Daniel" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Thursday, October 03, 2002 6:57 PM Subject: RE : Distribution List Problem is thoses users are from multiple different sites, multiples different countainers and I only have the smtp address. Going the import way, I need all thoses informations if I read correctly the export file I create yesterday night for testing. -----Message d'origine----- De : Daniel Chenault [mailto:[EMAIL PROTECTED]] Envoyé : 3 octobre, 2002 11:54 À : Exchange Discussions Objet : Re: Distribution List You already have the tool; it's called admin. Do a search in Exchange help for "admin import" ----- Original Message ----- From: "Bourque Daniel" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 10:48 PM Subject: Distribution List I have an Excel spreadsheet with 600 smtp e-mail address from some of my internal users and I need to semi-automatically create a Distribution List in Exchange. The DL will be update/recreate every month base on this file extract from an Oracle Database. I can cut and paste those smtp adress in an Outlook message to check/validate user resolution and have the application manager correct the list if necessary. What I have been looking for for the last 3 hours is a program to import this list in Exchange 5.5. Any idea of a tool, free if possible? I really don't need at this point a META Directory import/sync tool. Just a small prog/utility. Any idea? Daniel Bourque Analyste - Centre d'Assistance Technique Loto-Québec [EMAIL PROTECTED] (514) 499-5056 _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED]