 |
 | 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 / January 2007Data fields for Outlook & Access 2003
I have all of our employees in the contacts of Outlook 2003. I need to create reports that would include DOB, hire date, term date, gender, pay rates. I THINK that Access is the tool for creating these "reports". Can I still use Outlook as my only mode of data entry? Can I put all of the necessary data fields in the general tab of Outlook? I'll take my answer off the air. Please be gentle Gordon If you export your contacts to Access, can you then use that data source to generate the type of report you want in Access?  SignatureMilly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After furious head scratching, Gordon asked: | I have all of our employees in the contacts of Outlook 2003. | I need to create reports that would include DOB, hire date, term date, [quoted text clipped - 4 lines] | Outlook? I'll take my answer off the air. Please be gentle | Gordon That is what I plan to do. I'm having some difficulty configuring the dates to be mm/dd/yyy. I would aslo like to move or create the data entry fields in the "general" tab of the contact. I'm rather new at this and the though of creating another mother of all tables is not very pleasing. Thank you, Gordon > If you export your contacts to Access, can you then use that data source to generate the type of report you want in Access? > [quoted text clipped - 6 lines] > | Outlook? I'll take my answer off the air. Please be gentle > | Gordon Just a some things to remember: #1 - You'll need a 3rd party product to export custom fields on a regular basis - not handled by Outlook's Import/ Export function #2 - Just FYI - max # of fields in a single Access table is 255 #3 - Default date display is usually governed by your regional settings unless specific display formatting is applied Karl __________________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com > That is what I plan to do. > I'm having some difficulty configuring the dates to be mm/dd/yyy. [quoted text clipped - 16 lines] >> | Outlook? I'll take my answer off the air. Please be gentle >> | Gordon |
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
|
©2008 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.