Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

Outlook Staff List exported into Microsoft Access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Minnie - 28 May 2008 16:09 GMT
Our company has a large staff list/offices in Outlook.  It is a request that
I use that information and create a few different printouts.  There was no
suggestion on what software I should use for this process.  I am certainly no
pro when it comes to Access but, I presumed that it would be the best to use
for this process.  The problem is that I need to manipulate the information
in Access because for an example, the telephone number in Outlook contains a
telephone extension as well - I can't use this for these specific printouts.  
I'm having a very hard time creating the reports - there is information from
Outlook that is not consistent.  Is there a software program that you can
suggest I use that might be easier for me to work with?

Thank you for your help.
Minnie
Arvin Meyer [MVP] - 28 May 2008 16:24 GMT
I think Access may be the best platform to deal with Outlook data. Outlook
will directly export into an Access database. Small problems, like the need
to display only the phone number, without the extension are easily handled.

If the phone numbers contain parentheses, or dashes or spaces, they can be
removed by using an update query with the Replace function. Then in your
reports you can show, just the first 10 characters, and format them any way
you want.
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Our company has a large staff list/offices in Outlook.  It is a request
> that
[quoted text clipped - 16 lines]
> Thank you for your help.
> Minnie
Minnie - 28 May 2008 18:06 GMT
Thank you very much Arvin.  I'm sure I'll have more questions later.

Bye for now..............Minnie

> I think Access may be the best platform to deal with Outlook data. Outlook
> will directly export into an Access database. Small problems, like the need
[quoted text clipped - 24 lines]
> > Thank you for your help.
> > Minnie
 
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.