Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / May 2006

Tip: Looking for answers? Try searching our database.

Exporting my address book to excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Davy - 12 May 2006 02:25 GMT
Is there a way to export the address book from outlook to an excel (csv or
other) type of file?
The function exists ok in the outlook express address book - but I can't see
anything in outlook.

Any help appreciated,
John Davy
Sue Mosher [MVP-Outlook] - 12 May 2006 02:34 GMT
YOu didn't see the FIle | Import and Export command on Outlook's main menu?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> Is there a way to export the address book from outlook to an excel (csv or
> other) type of file?
[quoted text clipped - 3 lines]
> Any help appreciated,
> John Davy
John Davy - 12 May 2006 02:40 GMT
This seems to only allow you to export contacts from the contact folder - my
contacts are only listed inthe address book

YOu didn't see the FIle | Import and Export command on Outlook's main menu?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

> Is there a way to export the address book from outlook to an excel (csv or
> other) type of file?
[quoted text clipped - 4 lines]
> Any help appreciated,
> John Davy
IvKo - 12 May 2006 07:00 GMT
See "IMI GAL Exporter" - http://www.imibo.com/imidev/Exchange/imige.htm

IMI GAL Exporter for MS Exchange Server is small utility for Exchange Admin
to export GAL (Global Access List) to MS Access 2000 table.
Key Benefits
Obtain information about all the mailboxes on a MS Exchange Server 5.x
or/and  MS Exchange Server 2000
User can select more of Mailbox, Distribution List, Custom Recipient
properties from any Recipient container  in Organization Tree and export it.
The add-on named "IMI Distribution List Content Exporter" is small utility
for Exchange Admin to export content of DList  (Distribution List) to MS
Access 2000 table.

> This seems to only allow you to export contacts from the contact folder - my
> contacts are only listed inthe address book
[quoted text clipped - 9 lines]
> > Any help appreciated,
> > John Davy
John Davy - 18 May 2006 02:04 GMT
Thanks IvKo - I will give this a try

Kind Regards
John

> See "IMI GAL Exporter" - http://www.imibo.com/imidev/Exchange/imige.htm
>
[quoted text clipped - 28 lines]
>> > Any help appreciated,
>> > John Davy
Milly Staples [MVP - Outlook] - 12 May 2006 07:02 GMT
impossible - the Address Book is a virtual view of the Contacts folder.
Their is no physical Address Book as it has been obsolete for a few versions
now.  What version are you using?

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.  All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, John Davy asked:

| This seems to only allow you to export contacts from the contact
| folder - my contacts are only listed inthe address book
[quoted text clipped - 10 lines]
|| Any help appreciated,
|| John Davy
John Davy - 18 May 2006 02:04 GMT
I have outlook 2003 sp2

If I go to tools / address book (Ctrl Shift B) I can see my contacts there -
but they are not in my contacts folder

Kind Regards,
John

> impossible - the Address Book is a virtual view of the Contacts folder.
> Their is no physical Address Book as it has been obsolete for a few
[quoted text clipped - 15 lines]
> || Any help appreciated,
> || John Davy
Brian Tillman - 18 May 2006 14:15 GMT
> I have outlook 2003 sp2
>
> If I go to tools / address book (Ctrl Shift B) I can see my contacts
> there - but they are not in my contacts folder

If they're visible in the Address Book, then they MUST be in SOME Contacts
folder you currently have in your mail profile because the Address Book is
nothing but a view of those Contacts folders you have enabled as address
books.  Use the Folder List view to locate all of your Contacts folders.
Signature

Brian Tillman

Sue Mosher [MVP-Outlook] - 12 May 2006 12:24 GMT
If it's not a contacts folder, then what is the name of the address list that you want to export?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> This seems to only allow you to export contacts from the contact folder - my
> contacts are only listed inthe address book
>
> YOu didn't see the FIle | Import and Export command on Outlook's main menu?

>> Is there a way to export the address book from outlook to an excel (csv or
>> other) type of file?
[quoted text clipped - 4 lines]
>> Any help appreciated,
>> John Davy
John Davy - 18 May 2006 02:10 GMT
It's just called Outlook Address Book

Thanks
John

If it's not a contacts folder, then what is the name of the address list
that you want to export?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

> This seems to only allow you to export contacts from the contact folder -
> my
> contacts are only listed inthe address book
>
> YOu didn't see the FIle | Import and Export command on Outlook's main
> menu?

> "John Davy" <nospm_jdavy@adam.com.au> wrote in message
> news:OWbLiKWdGHA.3348@TK2MSFTNGP03.phx.gbl...
[quoted text clipped - 7 lines]
>> Any help appreciated,
>> John Davy
Sue Mosher [MVP-Outlook] - 18 May 2006 02:22 GMT
"Outlook Address Book" is the name of a container in the Address Book dialog in Outlook for address lists derived from your contacts folders. It contains no data itself and has no export function.

Under the Outlook Address Book container, you should see the names of Outlook contacts folders that you have chosen to expose in the address book. Do you see them? Are these what you want to export? What are their names?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx
 

> It's just called Outlook Address Book
>
[quoted text clipped - 22 lines]
>>> Any help appreciated,
>>> John Davy
John Davy - 18 May 2006 02:41 GMT
Thanks Sue

I think I must be just going a bit senile

"Outlook Address Book" is the name of a container in the Address Book dialog
in Outlook for address lists derived from your contacts folders. It contains
no data itself and has no export function.

Under the Outlook Address Book container, you should see the names of
Outlook contacts folders that you have chosen to expose in the address book.
Do you see them? Are these what you want to export? What are their names?

Signature

Sue Mosher, Outlook MVP
  Author of Configuring Microsoft Outlook 2003
    http://www.turtleflock.com/olconfig/index.htm
  and Microsoft Outlook Programming - Jumpstart for
    Administrators, Power Users, and Developers
    http://www.outlookcode.com/jumpstart.aspx

> It's just called Outlook Address Book
>
[quoted text clipped - 24 lines]
>>> Any help appreciated,
>>> John Davy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.