run multiple saved exports automatically

Question

So....right out of the box I am a newbie....

I am pretty sure I should be able to run several saved exports at one time with one command.

I am thinking I should be able to do it either with a macro or VBA...

However, when I try in a macro I see nothing in the drop down menu that says "RunSavedExport", so i assume that isn't an option and VBA scares the heck out of me:-)

So, can anyone offer some help?

I would need some very basic help if possible.

Even willing to go  the online video route if there is something out there to help me get over my VBA fears:-)

Thanks

Answer 1

There is a macro action RunSavedImportExport, but it's not listed by default.

In order to use it, your database must be stored in a Trusted Location. See Create, remove, or change a trusted location for your files for detailed information.

Next, open a macro in design view.

On the Design tab of the ribbon, in the Show/Hide group, click to highlight Show All Actions.

The RunSavedImportExport action should now be available.

You have to specify the name of the saved export.

You can add as many RunSavedImportExport actions to the macro as you want.

Good luck!

Answer 2

awesome... works great.

Thanks