Create xl from a distrib list

[Guest]

If I open the group, it does not give me the option of doing 'save as'. But
I was able to open an email, add the dl to the 'TO: box'. The dl appears in
the TO: box' with a plus. If you expand the plus, it gives you all of the
names delimited with a semicolon. I had to copy and paste the entire list to
a text file. The only problem is that when you try to open the resulting text
file in Excel, it opens the entire file as one row. So I copied and pasted
the one row to cell A3 with the 'paste-special' and transpose options. This
doesn't work so well because the original row cuts off most of the data
(Excel is limited in the column length). If I can't come up with a better
solution, I will have to do this process one piece at a time - very
cumbersome, but I do not see another solution. Maybe someone out there has
one??? Thanks.

 

[Sue Mosher [MVP-Outlook]]

How were we supposed to guess that you were referring to a GAL distribution list, especially when you referred to it as "one of my distribution lists"? See http://www.slipstick.com/contacts/print.htm#gal for ways to extract data from the GAL.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Sue,
I apologize for the confusion. I am not an experienced Outlook user and
am unfamiliar with this terminology. Thank you very much for the link.
Perhaps you can help me with one more thing? I need to create an Excel file
with the Outlook information including the user's alias (General tab in the
address book). How can I import the user information from one of my GAL
lists including the alias? Thanks again. Bryan

 

[Sue Mosher [MVP-Outlook]]

Do what I'd do: Pick one of the tools (which I haven't played with in years), try it, and see what you get. Your goal should be to get a comma- or tab-delimited file, which Excel will be able to handle quite well. Don't be afraid to experiment.

An alternative might be to use ADSI tools -- see http://www.outlookcode.com/d/adsi.htm

FYI, Exchange admins are probably better equipped to answer GAL questions than those of us who fool around with Outlook. It also sometimes helps if you explain what your real goal. Obviously, it's not just an Excel file but an Excel file ... that you'll use to do ___________?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[ProfDD]

If it's a one-time project, you could use Word to edit the file into
comma- or tab-delimited format and 'save as' plain text, then import
into Excel.

If it is to be regularly repeated, you need a solution with fewer steps.