Solved

Access and NEC phone system using Outlook

Posted on 2012-12-26
6
413 Views
Last Modified: 2013-01-02
Our office has just purchased and is installing a NEC phone system that will allow users to make calls from out of Outlook. I have no idea how it gets this done. I have an Access database that has contacts with phone numbers. I would like to be able to use the phone system from Access or through Outlook. Any suggestions?
0
Comment
Question by:JArndt42
  • 2
  • 2
  • 2
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38722606
Are you quite sure the NEC Phone is capable of doing this with MS Access?
Do you have the software?
Have you tried contacting NEC?
It would seem that if NEC  sold you the phone(s), they would be the best resource to tell you how to get this all working...

In any event, ...this was possible in older versions of Access, not sure about more current versions though...
See here:
http://support.microsoft.com/kb/148857

JeffCoachman
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38722949
We also have an old NEC system at work and supposedly they have an API so that you could control it via code but we couldn't find the API.  However, if you're system is new, as Jeff said, you should be able to contact NEC for support.  In our case, we just did a workaround by having the NEC softphone running, adding a label to a form, and running code similar to this:
    Dim numToCall As String
    numToCall = "5012"  'extension to call
    Me.lblPhoneNum.Hyperlink.Address = "callto:" & numToCall
    Me.lblPhoneNum.Hyperlink.Follow

Open in new window


Ron G.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38723742
Ron,
Any special hardware required?


...I'll leave this question to you, as I only posted what little info I had seen on this topic.

Jeff
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 1

Author Comment

by:JArndt42
ID: 38724056
Thank both of you. The phones are not plugged into each computer. They are all going to a NEC phone server and from there I have to assume they connect to the mail server. This may be way outside the scope of Access. I was just assuming that because it will call a contact in MS Outlook that it would be somewhat simple to get it to call a contact using MS Access.
0
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 38725777
The phones are not plugged into each computer.
With the solution I posted, you don't need a phone plugged into the computer.  You just need to install the NEC softphone.  Having said that, contacting NEC for the API would give you the most flexibility.
0
 
LVL 1

Author Closing Comment

by:JArndt42
ID: 38737535
Well I hope I can use this technology. I will let everybody know if this ends up working.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now