call phone number using Skype

Posted on 2011-05-01
Last Modified: 2012-08-13
I have an Access 2007 database and have a contact's number with the international dialing code added +44 xxx xxx xxxx (exapmple).  What I want is to double click on the phone number and dials the number in Skype.  I have added the Skype4com.dll but need some help in dialing the number.  I see a lot of code for recording calls and sending sms but nothing for just dialing the number in Skype.  Any one can help with this?
Question by:mtrussell
    LVL 44

    Expert Comment

    This thread asked by ptruswell (UK) has a lot of good info about what you are trying to do.  The additions by harfang are particularly helpful.

    Author Comment

    It is helpful  but I am needing more direct guidance in this to get started.  
    LVL 44

    Accepted Solution

    You have your numbers properly formatted with the plus sign and the international country code in a table.

    In a small form you are able to view the numbers in a combo box.  When you click on a number,  in the click event of the combo box insert this code:

    Private Sub cboSkypeNos()
      Application.FollowHyperlink "callto:" & Me.cboSkypeNos
    End Sub

    You will have to click Continue on a couple of popups, but Skype will dial that number.   Of course xxx xxx xxxx being some real number in the UK.  I'm not sure of the format for UK numbers - cboSkypeNos being the name of the combo box.  There were instructions in the referenced thread about getting rid of the popups.

    Author Closing Comment

    LVL 44

    Expert Comment

    Thanks, glad to help.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now