How to call a Microsoft office outlook Macro from C#

Question

I have a Macro which fetches some data into the excel file from the Microsoft office outlook (inbox or any other folder). To get the excel file I have to manually run the Macro in the outlook. Is there any way to call the Macro from the C#. I tried to search on Google but couldn’t find anything specific. This is an immediate requirement. Any help with this!!

gavlaaaaaaaa · Accepted Answer · 2013-06-19 10:29:21Z

1

Look here This should get you started.

its something along the lines of:

myApp = (Microsoft.Office.Interop.Outlook.ApplicationClass)(Marshal.GetActiveObject("Outlook.Application"));

then have a RunMacro(object theApp, object[] theArgs) method, then you will need to invoke a run on the app and the data inside this method.

edited Jun 19, 2013 at 10:29

answered Jun 19, 2013 at 8:58

gavlaaaaaaaa

6622 gold badges7 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

waris kantroo Over a year ago

Thank you. Would you please be kind enough and tell me how i have to specify the Macro path in C#. I am clueless.

gavlaaaaaaaa Over a year ago

theApp.GetType().InvokeMember("Run", System.Reflection.BindingFlags.InvokeMethod, null, theApp, theArgs); Im guessing something along these lines. Not tested though. Then run with: RunMacro(myApp, new Object[] { "macroName" });

Collectives™ on Stack Overflow

How to call a Microsoft office outlook Macro from C#

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related