Send outlook mail with outlook macros

hi all,

i’m currently trying to send an email using the outlook activity but the issue that i’m facing is that uipath bypasses my macro settings in outlook application, i do have a macro that runs whenever an email is being sent. however, the macro works when a new email is being sent manually but never works when the robot is sending the email…

any ideas folks?

Hi @kamal_hamad,

Before sending your email with UiPath, you could add an Invoke VBA activity https://docs.uipath.com/activities/docs/invoke-vba.
This new activity would invoke the macro you are speaking about

Hope this helps
Best regards,
Marius

@Marius_Puscasu i get what you’re talking about, actually the invoke vba thing works inside excel scope which i’m not using.

i have the macros set and working inside outlook application itself and what my macros do is they check whenever i try to send an email during non-working hours e.g after 5pm it then delays the email for the next day 8AM, the same way i’m trying to do with the emails sent from my bot so it doesn’t email the business users during night time as i 'm planning to run some unattended processes at midnight

do you get it?

@kamal_hamad,

Then, please use the FileName activity https://docs.uipath.com/activities/docs/start-process

Within the FileName filed you should add the absolute path of your outlook macro

Hope this helps
Best regards,
Marius