How can I specify which fields are linked from outlook tasks to an access
database table? The fields I require are not linked.
Since no one else has answered I'll jump in. This is something I posted
in relation to a similar question a few years ago:
The "fields" you see in the usual Outlook forms are only indirectly
related to the actual
data stored wherever that particular installation of Outlook stores
it. For instance, for Contacts there are
1) the "fields" in the usual Contacts form, which are a subset of
2) the much wider set of "contact fields" available in the Outlook
Define Views dialog, which correspond more or less one-to-one to
3) the *properties* exposed by the Contact object in the Outlook
object model, which are *not* the same as
4) the actual data fields that are stored.
And then there are
(5) the fields that appear when you try and export from or link to the
Contacts folder.
As I understand it, just what appears in (5) is determined to some
extent by the current view of the folder, so you might try altering
the view and re-linking to Access. Otherwise, you can always get
pretty much what you want by using the Outlook object model via
Automation.
Here are some useful links:
Accessing Microsoft Exchange and Outlook Data Using Visual Basic
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnout98/html/olexcoutlk.asp
Sample Procedure to Link a Microsoft Outlook Folder
http://support.microsoft.com/?id=209946
How to programmatically export Outlook items to Access
http://support.microsoft.com/?id=290792
http://support.microsoft.com/?id=253794
OL2000: How to Programmatically Import Outlook Items from Microsoft
Access
http://support.microsoft.com/?id=208232
Using Automation in Microsoft Office Access 2003 to Work with Microsoft
Office Outlook 2003
http://msdn.microsoft.com/library/d...ry/en-us/dno2k3ta/html/odc_ac_olauto.asp?_r=1
Finally, the best places I know for information about working with
Outlook are
http://www.outlookcode.com and
http://www.slipstick.com