Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2013, 09:47 AM
davesp davesp is offline Outlook, Excel or Access to mange contact details? Windows 7 64bit Outlook, Excel or Access to mange contact details? Office 2010 64bit
Novice
Outlook, Excel or Access to mange contact details?
 
Join Date: Jan 2013
Posts: 17
davesp is on a distinguished road
Default Outlook, Excel or Access to mange contact details?

Hello, I am looking to create a customer contact details page and would like to get opinions on whether should utilize the custom forms in Outlook Contacts, create an Access data base or (the easiest) setup an Excell spreadsheet.

I am new to custom Outlook forms and Access, but have taught myself how to code VBA for Excell, so I have some background in developement, if you can call it that.

I am leaning toward Outlook Contacts.

Background: I have 50+ customers, and one or more contact for each, in Outlook, which is good if I want to send them an e-mail. But if I want to look at the contract expiration date, I need to pull the paper contract or logn on to a different system and grab that info. If I want to find out what system the customer is on, I have to open a spreadsheet or Access database to get that info. There will be around 25 different data fields that I want to populate and preferably display on screen in a nice neat formated form as well as be able to export it to a spreadsheet to print.

I would prefer to have all that info in one easy to get to place that is available to me anytime, anywhere. That is why I am leaning to Outlook as I can access via OWA anywhere there is an internet connect. I also need to be able to share that detail with my backup.

If I am successfull at this, then I would want to make it available for my peers in the company...

So my questions are; what is your opinion,, Outlook, Access or Excel and then what reference materials, books, self help websites, beginners guides, etc would you recommend.

Thank you all.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook, Excel or Access to mange contact details? Import contact from EXCEL to Outlook (no zero in left side digit) nmo111 Outlook 1 05-28-2010 11:00 AM
Hide contact details AndyKC Outlook 0 01-25-2010 11:00 PM
Transfer of account details to Outlook 2003 on Windows7 taralastair Outlook 1 01-04-2010 01:24 PM
Entering Contact details GemmaD Outlook 0 12-18-2008 06:41 AM
program trying to access contact list sbarrett Outlook 0 09-11-2006 12:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft