We are a group of users of Blackbaud products and are not affiliated with Blackbaud. We'd love to have you join our community to help and be helped in getting the most from your Blackbaud software.
Register now to join us to get independant advice on your system, connect with 3rd party consultants to help you maximize your database and have a real alternative to the official Blackbaud website.
We have a macro that runs each time a constituent is saved or a gift batch is posted that reviews preferred address and assigns a chapter code. We do imports from time to time of new constituents that does not trigger the macro. Does anyone know if you can schedule a macro to run nightly? RE Queue can't do it.
The only way of doing this is to create a standalone application of the macro using the API. Once you have done that you can use Windows scheduler to run the application nightly. It is quite straight forward to do. You just have to connect to the API with the correct credentials and then run the macro in the same way. Once you compile this into an application you can select this application to run through the scheduler.
Of course this supposes that you have the API and not just VBA modules.
To paraphrase a noted politician, "YES WE CAN... we just need a little bit more software."
It is possible to schedule a Raiser's Edge VBA Macro to run daily (or nightly, as the case may be), we just need a little help from our friends. Here's a video that shows how it can be done:
Linear Mode
