Forum Discussion

Rahul Balaraddi's avatar
Rahul Balaraddi
Former Employee
May 09, 2018

Schedule a task to run a Excel macro which sends out a Outlook email in Windows Server 2012R2

I have created an Excel VBA code to trigger a mail with data. I am trying to set it up on a remote machine(Windows Server 2012R2 Operating System) to run at a scheduled time. 

Need help regarding -

1) The excel is working fine but the scheduler doesn't work when the user is not logged in. 

2) The outlook is throwing a pop up asking for permission to send the mail. I installed Antivirus made necessary changes in Programmatic access but it the changes disappeared when new system updates were released.

 

Kindly help.

Thanks

No RepliesBe the first to reply

Resources