ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Addresses (https://www.excelbanter.com/excel-discussion-misc-queries/138198-addresses.html)

Oggy

Addresses
 
Hi

Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?

Thanks

Oggy


Gary''s Student

Addresses
 
Here is a good approach:

1. From Address Book:
File Export Other Address book... Text File (Comma Separated Values)
The Wizard will permit you to select which fields are to be exported.

2. From Excel, just open the .csv file created in step #1


--
Gary''s Student - gsnu200713


"Oggy" wrote:

Hi

Can anyone please advise me how i can insert a name and address from
the microsoft address book into a exel spreadsheet. If this cannot be
done what alternitives are there?

Thanks

Oggy




All times are GMT +1. The time now is 05:54 AM.

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