linking outlook data to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
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...
 
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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
It was worse than I believed - you must have an email address to have the
record linked...
 
Back
Top