Start MS Outlook with an Outlook macro

[gjbbroekhuis]

Hi,

Is it possible to start MS Outlook from a VFP application with an Outlook macro?

In my Outlook 2016 I have a fully operational macro "MyMacro", enabled with a certificate.
This macro does certain things with the selected e-mail message. This is all working fine.
Now I would like to start Outlook from my VFP application with this macro.

Regards, Gerrit

 

[Mike Lewis]

You should be able to do this via the Application.Startup event in Outlook. Essentially it's a matter of running the macro from that event. For more details, see

https://docs.microsoft.com/en-us/office/vba/api/outlook.application.startup.

To launch Outlook from VFP, you can use ShellExecute(). If you don't know how to do that, see

http://www.ml-consult.co.uk/foxst-26.htm

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads