how to get output from Macro to be input to Email in PAD flow

(0) Share

Report

Posted on by Zy_Sin

Hi,

I have this PAD flow

how do i get the Run.NET script to have the output of the Macro message?

i think my set variable is incorrect?

how do i get the from my vba script this variable macro1_output_msg out to my PAD email?

kindly help with the syntax. Thanks

this is my VBA script

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Zy_Sin

whatever you are passing to input to Run .Net script action is correct >

Bit confused on how you are getting the output - macro1_output_msg out from run macro ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

to simplify the above
i have a macro script and i need to get the output from macro run as a input in the Email. but the PAD Run Excel macro only allow us a input into macro but not output from macro

the Run Excel macro ;argOutput is a input into macro which i do not need to, is there a way to get the output "Something vomit" out and to be inside my Email {0}?

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Zy_Sin

Run Macro action does not give you output value coming out of that macro, You can only pass values to macro via run macro but cannot take any output values from it. Other way would be to write the out argument/output from macro run in a file and make the bot to read from it.

Go through this article for better reference

https://www.samurai-emblem.com/2023/04/07/power-automate-desktop-action-run-macro-excel/#google_vignette

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Zy_Sin 79 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Nived_Nambiar

That's what i did.

Was this reply helpful? Yes No