Hello, I am trying to export outlook emails to an excel spreadsheet.
I compiled and run the following code which executes very well:
I would like to schedule the execution of the macro with Windows Scheduler.
My concern is that, when the macro starts, I get the prompt to provide my OutLook Profile Name. Afterwards, I receive another prompt to provide Entrust username and password.
Is there any way to wrap security information (OutLook Profile Name, Entrust username and password) into the macro code?
Thanks in advance.