Discussion:
How to export mailbox name, email account and alias in exchange 20
(too old to reply)
Kaddie
2008-01-15 03:59:00 UTC
Permalink
Hi, We need to export 400 or so mailboxes out to a CSV type file once a month
so that an external client can import them into their contacts list. In
exchange 2007 is there a cmdlet for this. We would just want the name of
user, alias and email address. Can we do this from exchange or should we use
the ldifde -f export.ldf (-s Servername) in Active directory instead (this is
just an example command I found on the internet). If anyone knows how to do
this we would greatly appreciate some assistance
thanks
--
Kath
2008-01-15 06:09:40 UTC
Permalink
you can use both.
or if you like GUI - see IMI GAL and Distribution List Export
http://www.imibo.com/imidev/Exchange/imige.htm

This is all - no scripts, no params, no... Easy and fast
Post by Kaddie
Hi, We need to export 400 or so mailboxes out to a CSV type file once a month
so that an external client can import them into their contacts list. In
exchange 2007 is there a cmdlet for this. We would just want the name of
user, alias and email address. Can we do this from exchange or should we use
the ldifde -f export.ldf (-s Servername) in Active directory instead (this is
just an example command I found on the internet). If anyone knows how to do
this we would greatly appreciate some assistance
thanks
--
Kath
b***@googlemail.com
2008-01-20 18:59:02 UTC
Permalink
Post by Kaddie
Hi, We need to export 400 or so mailboxes out to a CSV type file once a month
so that an external client can import them into their contacts list.  In
exchange 2007 is there a cmdlet for this.  We would just want the name of
user, alias and email address.  Can we do this from exchange or should we use
the ldifde -f export.ldf (-s Servername) in Active directory instead (this is
just an example command I found on the internet).  If anyone knows how to do
this we would greatly appreciate some assistance
thanks
--
Kath
Well you can do the folowing. Open Exchange Comannd Shell and run the
folowing comandlet:

get-mailbox | ft name, alias, PrimarySmtpAddress > C:\email.csv

This will export what you need and store it in a csv format under c:
\email.csv



Bujar Lushta
Shay Levi
2008-01-20 19:03:25 UTC
Permalink
Try:

get-mailbox | select-object name, alias, primarySmtpAddress | Export-Csv
C:\mailboxes.csv -NoTypeInformation


-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com
Post by b***@googlemail.com
Post by Kaddie
Hi, We need to export 400 or so mailboxes out to a CSV type file once a month
so that an external client can import them into their contacts list.
In
exchange 2007 is there a cmdlet for this. We would just want the
name of
user, alias and email address. Can we do this from exchange or
should we use
the ldifde -f export.ldf (-s Servername) in Active directory instead (this is
just an example command I found on the internet). If anyone knows
how to do
this we would greatly appreciate some assistance
thanks
--
Kath
Well you can do the folowing. Open Exchange Comannd Shell and run the
get-mailbox | ft name, alias, PrimarySmtpAddress > C:\email.csv
\email.csv
Bujar Lushta
Shay Levi
2008-01-20 19:08:46 UTC
Permalink
Bujar,

Format-* cmdlets are designed to be the last commands in the pipeline. They
render the piped objects into text that can be
displayed in the console.

Your example ends up as formated text and not as a structured CSV file. Kath
won't be able to import it later on.

-----
Shay Levi
$cript Fanatic
http://scriptolog.blogspot.com
Post by b***@googlemail.com
Post by Kaddie
Hi, We need to export 400 or so mailboxes out to a CSV type file once a month
so that an external client can import them into their contacts list.
In
exchange 2007 is there a cmdlet for this. We would just want the
name of
user, alias and email address. Can we do this from exchange or
should we use
the ldifde -f export.ldf (-s Servername) in Active directory instead (this is
just an example command I found on the internet). If anyone knows
how to do
this we would greatly appreciate some assistance
thanks
--
Kath
Well you can do the folowing. Open Exchange Comannd Shell and run the
get-mailbox | ft name, alias, PrimarySmtpAddress > C:\email.csv
\email.csv
Bujar Lushta
h***@gmail.com
2014-05-07 00:16:43 UTC
Permalink
Post by Kaddie
Hi, We need to export 400 or so mailboxes out to a CSV type file once a month
so that an external client can import them into their contacts list. In
exchange 2007 is there a cmdlet for this. We would just want the name of
user, alias and email address. Can we do this from exchange or should we use
the ldifde -f export.ldf (-s Servername) in Active directory instead (this is
just an example command I found on the internet). If anyone knows how to do
this we would greatly appreciate some assistance
thanks
--
Kath
Hi Kath,

I put together a quick blog post on exporting email addresses to CSV or TXT using Exchange Management Shell or the LDIFDE utility - I wanted to share it to make life easier for people who find this old-old thread like I did.
http://enterpriseit.co/microsoft-exchange/export-list-of-all-exchange-email-addresses-and-aliases/

It also includes a link for exporting email addresses / alias's using the GUI.

Hope it's helpful, it was a pain to figure out,

Chris

Loading...