Re: Directory Export - SMTP address
The simplest way to do this, IIRC, is to add email addresses as a column when you're viewing the Recipients container (or the GAL) from Admin. You can do a File | Save Window Contents As... (or something like that - I don't have Admin here) and dump that to a csv. Missy - Original Message - From: Hatley, Ken [EMAIL PROTECTED] To: Exchange Discussions [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 2:39 PM Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
Not necessarily. Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant hp Services Protecting the world from PSTs and Bricked Backups! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Listserver, Exchange MSER:EX Sent: Friday, February 07, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address If the SMTP address is the default address for the mailbox, then you could use LDIFDE or CSVDE from a Windows 2000 box and export the LDAP mail attribute. Steve Smith Common IT Services Ministry of Management Services Province of British Columbia email: [EMAIL PROTECTED] Phone: (250) 387-8698 -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: February 6, 2003 11:39 AM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
If the SMTP address is the default address for the mailbox, then you could use LDIFDE or CSVDE from a Windows 2000 box and export the LDAP mail attribute. Steve Smith Common IT Services Ministry of Management Services Province of British Columbia email: [EMAIL PROTECTED] Phone: (250) 387-8698 -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: February 6, 2003 11:39 AM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
Directory Export - SMTP address
How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
Are these utils on the E2K cd? __ John Bowles Exchange Administrator Messaging Team Celera Genomics [EMAIL PROTECTED] -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:43 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
I usually import the csv into excel and manipulate from there. Dave Stevens -IT Network Support- email: [EMAIL PROTECTED] 865-576-8898 -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
RE: detail of your original Q: I do not think you can...your going to get the whole 'E-mail Addresses' field you could then chop it up with you favorite admin tools to extract just the SMTP: Im with steve I mess it up good in excel True I find mainly 'E-mail Addresses' which has everything I tend to screw up myself. now there's a 'Secondary-Proxy-Addresses' field with small 'smtp' But I do think if you want to modify someones stuff you have to use the smtp under 'E-mail Addresses' which in capitalized SMTP: I believe what ever follows the SMTP: in that field will update the entries SMTP Note the captial SMTP is key for their default smtp address...at least thats what my memory is telling me right now... bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
Without knowing what the end result of the export is, would adding the e-mail address (Internet) column to the view of the admin tool and then save window contents get you what you need?? Bob -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 3:07 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address RE: detail of your original Q: I do not think you can...your going to get the whole 'E-mail Addresses' field you could then chop it up with you favorite admin tools to extract just the SMTP: Im with steve I mess it up good in excel True I find mainly 'E-mail Addresses' which has everything I tend to screw up myself. now there's a 'Secondary-Proxy-Addresses' field with small 'smtp' But I do think if you want to modify someones stuff you have to use the smtp under 'E-mail Addresses' which in capitalized SMTP: I believe what ever follows the SMTP: in that field will update the entries SMTP Note the captial SMTP is key for their default smtp address...at least thats what my memory is telling me right now... bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
RE: Directory Export - SMTP address
No, need it with several other fields...I just did a text to columns in excel and got what I needed. Thanks all. -Original Message- From: Schuessler, Bob (Efdsouth) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:13 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address Without knowing what the end result of the export is, would adding the e-mail address (Internet) column to the view of the admin tool and then save window contents get you what you need?? Bob -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 3:07 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address RE: detail of your original Q: I do not think you can...your going to get the whole 'E-mail Addresses' field you could then chop it up with you favorite admin tools to extract just the SMTP: Im with steve I mess it up good in excel True I find mainly 'E-mail Addresses' which has everything I tend to screw up myself. now there's a 'Secondary-Proxy-Addresses' field with small 'smtp' But I do think if you want to modify someones stuff you have to use the smtp under 'E-mail Addresses' which in capitalized SMTP: I believe what ever follows the SMTP: in that field will update the entries SMTP Note the captial SMTP is key for their default smtp address...at least thats what my memory is telling me right now... bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:52 PM To: Exchange Discussions Subject: RE: Directory Export - SMTP address It is for 55, but the only header I see is 'E-mail Addresses' and that gives the full DN, is there a header to just grab the SMTP address? -Original Message- From: Mellott, Bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 1:43 PM To: Exchange Discussions Subject:RE: Directory Export - SMTP address in 55 you needed HEADER.EXE at least thats the way I did it, Im sure there are other ways bill -Original Message- From: Hatley, Ken [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 2:39 PM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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] _ 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]
RE: Directory Export - SMTP address
You cannot export just the SMTP address. You can export all the addresses and then parse out the SMTP addresses by exporting the E-Mail Addresses and Secondary-Proxy-Addresses fields, and, for custom recipients, the E-Mail Address field. Ed Crowley MCSE+Internet MVP kcCC+I Tech Consultant hp Services Protecting the world from PSTs and Bricked Backups! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Hatley, Ken Sent: Thursday, February 06, 2003 11:39 AM To: Exchange Discussions Subject: Directory Export - SMTP address How do you export the SMTP address without the entire DN using admin.exe to export to a .csv file? _ 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]
