MARS

MARS makes it easy to automate Microsoft Access Reports. Simply define a single, or packages, of Microsoft Access Reports, set the schedule and automatically send reports to print, fax, folder, FTP, SMS, DropBox, Sharepoint and email, in a number of standard formats including Excel, Word, PDF and RPT. By automating repetitive reporting tasks, MARS - Microsoft Access Reports Scheduler - ensures that reports are created and distributed when needed, without error, and without costly support time.

Event Triggers

MARS - Set output format options for a merged Excel file before delivery.

MARS - Create a Package of Reports.A report pack can be sent to a client with all reports compressed into a single zip file, or merged into one Excel workbook.

MARS - Blank report Exception handling.If a report genuinely has no data behind it, MARS can be configured to do a number of things with the report & schedule.

MARS - Exception Handling.Should an error occur define the action(s) MARS should follow.

MARS - Set MS Word output format options.For MS Word (DOC): Set document properties (Title, Author, Company, etc) choose from Uncompressed, LZW, RLE.

MARS - Set MS Excel output format options.For MS Excel (XLS), Data Only, Excel 7, 8, & 97-2000: burst report groups into separate worksheets in the same workbook.

MARS - Set CSV output Format options.Use any character separator, or use "tab", choose comma, or any delimiter (or not, if you do not require one).

MARS - Set Acrobat output format options.Add watermarks, bookmarks, set properties e.g title. Add password protection e,g. Print, Edit, Owner & User Passwords.

MARS - Merge PDF Files.Use Automation Schedules to Merge PDF files in a specified folder.

MARS - Add several Custom Actions to the same Schedule.Create your own workflows by adding as many Custom Actions to an Automation Schedule.

MARS - Custom Actions.Use Custom Actions pre or post-delivery of a schedule to create a workflows.

MARS - Set up a package of Dynamic and Data Driven Reports.Packages make it easy to send many reports in the same email. Reports can be zipped before delivery and password protected.

MARS - Create a Data Driven Email.Use Data Driven inserts to populate an email with Names, Dates, Order numbers and much more.

MARS - Set up a Data Driver.Use the data in your database to populate Report Parameters, destinations, formats and much more.

MARS - Set up a Dynamic destination.MARS will automatically enter the required parameter values, export and deliver the report to the corresponding email.

MARS - Compose a Dynamic email.Using Dynamic inserts MARS will automatically enter the required values from your own database.

MARS - Run Access Reports on your own schedule.Can’t find what you need? Use Custom Calendars to set your own business driven scheduling frequency e.g. 4-4-3.

MARS - Schedule Access Reports for the 1st day of every Month.Schedule a report on the 1st day of every Month except for certain user specified dates.

MARS - Schedule your Month End Access Reports.Schedule a report to run the last day of every Month at a set time.

MARS - Schedule a Report to run daily.Schedule a report to run every day at a set time excluding specific days by using exception calendars.

MARS - Create your desired scheduling frequency.Set a schedule weekly on a Sunday and a Monday at a set time. Repeat the schedule every x minutes until a certain time.

Click for more

Image 1 / 23

MARS has easily paid for itself several times over.

Karl Glover, Logistics Support Manager, Virgin Media

MARS Features

Easy To Use - Simply set up a "schedule" stating how often you would like each report to run, whether you'd like the output in Word, Excel, HTML, RTF, Acrobat, RPT, text format etc and who it should be sent to. MARS will do the automated delivery for you, delivering reports to folder, email, printer, fax, DropBox, Sharepoint, FTP or SFTP.
Date and Time Scheduling - It's easy to schedule Microsoft Access Reports to run at a specific date and time, or to run them hourly, daily...

Learn more about MARS

Latest News

MARS 7.0 Build 20180517

Adds new user interface when executing schedules manually.

New Version | May 29, 2018 - 9:17

MARS 7.0 Build 20180419

Adds compatibility with Microsoft Access 2016 Full Version (not "Click-To-Run").

New Version | April 23, 2018 - 15:32

MARS released

Automated scheduling and delivery of Microsoft Access reports, queries and macros.

New Product | February 22, 2018 - 12:28

Prices from: $ 9,811.51

MARS is licensed based on the number of Report Outputs a Day. A simple formula is used to determine the daily peak output: (Data Count *Report Count * Destination Count) = Total Report Output: Data...