Extracting hours from Outlook via Access

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

Guest

What I am trying to do is create an access database by linking to Outlook
calendar which will allow me to track time using Access reports. Was able to
create the link successfully but start/end and dates/times for appointments
do not appear in the database table. Any suggestions on getting the the
appointement start/end dates/times?
 
The linked table method has major limitations, including the inability to show even all the reasonably important fields. While articles have been written on how to expand on this method's obvious features, I've never been able to duplicate the results. See http://www.outlookcode.com/d/database.htm#linkedtables .

That page will also give you other ideas on how to work with databases and Outlook together. You'll need to write code or use a third-party tool that does the heavy lifting.

There's also the quick and dirty method:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. Paste to Excel.



--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Thanks Sue. I have done that before. It's a hassle but does work. The only
limitation I can't seem to get around there is the recurring appointments
don't show as individual appointments so the hours can't be totaled for an
individual week. Any suggestions?
 
Suggestions? Write your own code to iterate the items or see if any of the third-party tools can help.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top