How to run a simple VBA function in Outlook from a PowerShell script

Question

Hi,

I've have a simple function in an Outlook VBA module that I want to run from a PowerShell script.

I'm already sending emails using PowerShell so I guess my script should start with something like:

$outlook = new-object -comobject outlook.application 

But I don't know how to call the VBA function.

Would anybody have done that already? Thanks for any advise.

Answer 1

You can try something like this:

# Create the Outlook application object
$outlookApp = New-Object -ComObject Outlook.Application
# Get the VBA project
$vbaProject = $outlookApp.Project1	# or maybe ThisOutlookSession????
# Run the macro
$vbaProject.Application.Run("MySub")

Note: Not tested!

I'm not familiar with VBA/Outlook. I'm not sure of the name used as the project.