Forums/Community Help

WinXP, Outlook 2007, VBA Macro integration

Mitchell Mann
posted this on April 3, 2012, 16:23

Hi there,

I am trying to integrate a macro written in VBA (Visual Basic for Applications) in Microsoft Outlook 2007 on Win XP with myPhoneDesktop - I can successfully place the required data in the system clipboard but I can not initiate the shortcut key combination using the SendKeys to actually post this data to the myPhoneDesktop app and get it to send the SMS (which is what I'm trying to do).

Have you successfully used SendKeys to trigger myPhoneDesktop on Win XP? Or do you have any sample scripts/code relating to Windows integration as all the files online seem to be Mac oriented.
 

Comments

User photo
myPhoneDesktop Support
myPhoneDesktop

The following example will trigger default myPhoneDesktop shortcut for windows using SendKeys method (example is using VBA in Excel 2010):

Sub SendToMyPhoneDesktop() 
  ActiveCell.Formula = "212-555-1212" 
  ActiveCell.Copy 
  Application.Wait (Now() + TimeValue("00:00:01"))
  SendKeys "+^%({f11})", False
End Sub

 

Keep in mind that you can override default shortcut via settings in myPhoneDesktop's application.ini

shortcut.integration.default = shift control alt F11
April 5, 2012, 02:38
User photo
Freddie

I had been using this method on my software for a about 6-9 months without problems. However recently, I'm not sure what I upgraded but it's no longer working.

When I go into myPhoneDesktop and press shift alt ctrl f11 and it's working, but it's not working from my ms access.

I checked my ini file and it's correct

shortcut.integration.default = shift control alt F11

What could be the problem? Is it a settings on my computer?

October 17, 2012, 02:01
User photo
myPhoneDesktop Support
myPhoneDesktop

Please ellaborate exactely what you are doing / how from MS Access (demo project will help as well).

--
Kind Regards,
Alex 

October 17, 2012, 10:53
Add a comment