|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
December 4th 06, 12:32 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Can Outlook Address Book be an Excel Data Source
I know that the Outlook Address Book can be used as a database source for
mail merge in Word & Publisher. I would expect that Excel would also have access to that address book via its Data Import External data capability. But, I don't know how to set that up. Any ideas? Thanks, Jim 
|
|
#2
December 4th 06, 02:05 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Can Outlook Address Book be an Excel Data Source
Are you aware that there is no Outlook Address Book? It is simply a view of
Outlook's Contacts Folder. You can certainly export your Contacts Folder to an Excel file if you want. -- Russ Valentine [MVP-Outlook] "Jim Walsh" wrote in message ... I know that the Outlook Address Book can be used as a database source for mail merge in Word & Publisher. I would expect that Excel would also have access to that address book via its Data Import External data capability. But, I don't know how to set that up. Any ideas? Thanks, Jim
|
|
#3
December 4th 06, 07:52 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Can Outlook Address Book be an Excel Data Source
Hi Russ,
Yes, I kind of knew that "Address Book" was one view of a Contacts Folder. But, my question is about some interface from Excel into Outlook Contacts folder. Maybe something like ODBC, or OLE DB, etc. Both Word and Publisher seem to have some kind of access in which the user can make selections about what actually gets imported. Do you know of anything like that for Outlook contacts -- EXCEL? Jim "Russ Valentine [MVP-Outlook]" wrote in message ... Are you aware that there is no Outlook Address Book? It is simply a view of Outlook's Contacts Folder. You can certainly export your Contacts Folder to an Excel file if you want. -- Russ Valentine [MVP-Outlook] "Jim Walsh" wrote in message ... I know that the Outlook Address Book can be used as a database source for mail merge in Word & Publisher. I would expect that Excel would also have access to that address book via its Data Import External data capability. But, I don't know how to set that up. Any ideas? Thanks, Jim
|
|
#4
December 4th 06, 09:29 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Can Outlook Address Book be an Excel Data Source
Only Outlook's Export Wizard, which certainly allows you to customize what
fields are exported to Excel. -- Russ Valentine [MVP-Outlook] "Jim Walsh" wrote in message ... Hi Russ, Yes, I kind of knew that "Address Book" was one view of a Contacts Folder. But, my question is about some interface from Excel into Outlook Contacts folder. Maybe something like ODBC, or OLE DB, etc. Both Word and Publisher seem to have some kind of access in which the user can make selections about what actually gets imported. Do you know of anything like that for Outlook contacts -- EXCEL? Jim "Russ Valentine [MVP-Outlook]" wrote in message ... Are you aware that there is no Outlook Address Book? It is simply a view of Outlook's Contacts Folder. You can certainly export your Contacts Folder to an Excel file if you want. -- Russ Valentine [MVP-Outlook] "Jim Walsh" wrote in message ... I know that the Outlook Address Book can be used as a database source for mail merge in Word & Publisher. I would expect that Excel would also have access to that address book via its Data Import External data capability. But, I don't know how to set that up. Any ideas? Thanks, Jim
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sending email from source Excel spreadsheet | Richard Edwards | Outlook - General Queries | 1 | August 9th 06 07:15 PM |
| Extract Outlook Address book properties into Excel | Junoon | Outlook and VBA | 11 | June 30th 06 12:17 AM |
| Exporting my address book to excel | John Davy | Outlook - Using Contacts | 13 | May 18th 06 02:15 PM |
| how do I get my contacts from excel to show up in my address book | Houston Texas | Outlook - Using Contacts | 10 | February 22nd 06 01:07 AM |
| Outlook 2002 copy address book to external source | tom | Outlook - Using Forms | 0 | February 19th 06 02:11 AM |
Hybrid Mode
