ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Address Book - Outlook (https://www.excelbanter.com/excel-programming/307637-address-book-outlook.html)

Thompson, Joseph[_2_]

Address Book - Outlook
 
How does one import the address book or a global address list into a
worksheet?



david mcritchie

Address Book - Outlook
 
Hi Joseph,
See http://www.mvps.org/dmcritchie/excel/ofc2000.htm
see topic "Exporting Address Book to make modification in a Spreadsheet"

Basically you go to the address book, use File, Export, as other file,
select CSV file, open that file from Excel.

If you do make modifications to your address book, I would make a copy of your
addressbook (.WAB) and store it offline.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Thompson, Joseph" wrote in message ...
How does one import the address book or a global address list into a
worksheet?






All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com