how to amend the vba in outlook to a VBScript?

Hi all,

here is the code of my VBA in outlook,

as i want to put it in the task scheduler to run it on a fixed time daily.

but how can it be done?

Please Login or Register  to view this content.

Many thanks all.

VBS is very similar to VBA, and VBA legacy in any version, for that matter. for instance, the MGSBOX is the same statement between the two. you biggest hurdle, more than likely, will be to try and find out if the outlook object references in your code, like the MAPI line, can be done in VBS. more than likely it can.

however, why do you need a shell language? why not just open outlook and run your code by way of a TS timer? that's what you want to do anyway, right? some IT departments actually block VBS files from running because it is looked at as malicious. you can open literally anything with the TS in windows, if I'm not mistaken.

Many thanks for your reply
Yes you are right, my purpose is to run the ooutlook macro daily at a specific time.
as I have some excel macro and it is easy to convert them into vbs for a task scheduler to run. therefore it become my first thought to convert the outlook macro to a vbs file.
how can I run the outlook macro in task scheduler without using vbs?

I don't run tasks often. can't be much help there.

https://www.google.com/search?q=outl...task+scheduler

looks like many have already done it, and can assist you.