 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / June 2006linking 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 I want to do this as well. > hey, > I wanted to link the business contacts data to a excel file. [quoted text clipped - 5 lines] > > manish 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.  SignatureSue 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 > hey, > I wanted to link the business contacts data to a excel file. [quoted text clipped - 5 lines] > > manish 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... > 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. > > hey, [quoted text clipped - 6 lines] > > > > manish 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 . SignatureSue 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 > 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 [quoted text clipped - 12 lines] >> > >> > manish It was worse than I believed - you must have an email address to have the record linked... > 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 . > > Funny enough, if you create a linked table from Outlook|contacts to an ..mdb [quoted text clipped - 13 lines] > >> > > >> > manish |
Reply to this Message |
 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
|
©2009 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.