|
| 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. |
|
|||||||
| Tags: data, excel, linking, outlook |
|
|
Thread Tools | Display Modes |
|
#1
April 11th 06, 07:53 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
linking outlook data to excel
hey,
I wanted to link the business contacts data to a excel file. I prepare invoices regularly. I want that the name of person be validated through outlook contact and the rest details, such as address can be link directly in the file regards manish 
|
| Ads |
|
#2
April 21st 06, 11:52 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
linking outlook data to excel
I want to do this as well.
"manish chulawala" wrote: hey, I wanted to link the business contacts data to a excel file. I prepare invoices regularly. I want that the name of person be validated through outlook contact and the rest details, such as address can be link directly in the file regards manish
|
|
#3
April 27th 06, 09:12 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
linking outlook data to excel
Nothing like that is built into Outlook. Microsoft does, however, provide the "smart tags" feature for that kind of integration. You (or someone else) would have to program a smart tag to perform the functions you want.
-- 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 "manish chulawala" wrote in message ... hey, I wanted to link the business contacts data to a excel file. I prepare invoices regularly. I want that the name of person be validated through outlook contact and the rest details, such as address can be link directly in the file regards manish
|
|
#4
June 8th 06, 01:55 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
linking outlook data to excel
Funny enough, if you create a linked table from Outlook|contacts to an .mdb
Access database you could retrieve the data from outlook to excel. The only culprit: The "display as" field must be nonempty in the contact records to transfer... "Sue Mosher [MVP-Outlook]" wrote: Nothing like that is built into Outlook. Microsoft does, however, provide the "smart tags" feature for that kind of integration. You (or someone else) would have to program a smart tag to perform the functions you want. -- 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 "manish chulawala" wrote in message ... hey, I wanted to link the business contacts data to a excel file. I prepare invoices regularly. I want that the name of person be validated through outlook contact and the rest details, such as address can be link directly in the file regards manish
|
|
#5
June 8th 06, 02:15 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
linking outlook data to excel
Well, the linked table method has major limitations, including the inability to show even what I'd consider all the reasonably important fields. But maybe it's enough for manish. While articles have been written on how to expand on the link method's obvious features, I've never been able to duplicate the results. YMMV. See http://www.outlookcode.com/d/database.htm#linkedtables .
-- 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 "Gunnarh" wrote in message ... Funny enough, if you create a linked table from Outlook|contacts to an ..mdb Access database you could retrieve the data from outlook to excel. The only culprit: The "display as" field must be nonempty in the contact records to transfer... "Sue Mosher [MVP-Outlook]" wrote: Nothing like that is built into Outlook. Microsoft does, however, provide the "smart tags" feature for that kind of integration. You (or someone else) would have to program a smart tag to perform the functions you want. "manish chulawala" wrote in message ... hey, I wanted to link the business contacts data to a excel file. I prepare invoices regularly. I want that the name of person be validated through outlook contact and the rest details, such as address can be link directly in the file regards manish
|
|
#6
June 8th 06, 03:42 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
linking outlook data to excel
It was worse than I believed - you must have an email address to have the
record linked... "Sue Mosher [MVP-Outlook]" wrote: Well, the linked table method has major limitations, including the inability to show even what I'd consider all the reasonably important fields. But maybe it's enough for manish. While articles have been written on how to expand on the link method's obvious features, I've never been able to duplicate the results. YMMV. See http://www.outlookcode.com/d/database.htm#linkedtables . -- 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 "Gunnarh" wrote in message ... Funny enough, if you create a linked table from Outlook|contacts to an ..mdb Access database you could retrieve the data from outlook to excel. The only culprit: The "display as" field must be nonempty in the contact records to transfer... "Sue Mosher [MVP-Outlook]" wrote: Nothing like that is built into Outlook. Microsoft does, however, provide the "smart tags" feature for that kind of integration. You (or someone else) would have to program a smart tag to perform the functions you want. "manish chulawala" wrote in message ... hey, I wanted to link the business contacts data to a excel file. I prepare invoices regularly. I want that the name of person be validated through outlook contact and the rest details, such as address can be link directly in the file regards manish
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can I import data from Excel into Outlook | Sheila | Outlook - Using Contacts | 3 | April 17th 06 10:57 PM |
| Please Help ! Problem updating excel data into access DB | sug sri | Outlook and VBA | 1 | March 21st 06 07:03 AM |
| Linking an Excel Spreadsheet to Outlook | KevinM | Outlook - Calandaring | 1 | February 15th 06 11:51 PM |
| Linking excel into exchange 2003 public folder | Richard Edwards | Outlook - Using Forms | 0 | January 23rd 06 03:00 PM |
| IMPORT ADDITIONAL DATA FROM EXCEL TO OUTLOOK CONTACTS | greek evangelos | Outlook - Using Contacts | 1 | January 8th 06 05:23 AM |
Linear Mode
