Documents

How to automatically and regularly send reports to colleagues

Q: I am a database administrator. I need to send some reports to my colleagues every week. I want to automate this process. How should I do it? Specifically, I would like to send the following report every Monday and on the last day of each month.

A: Yes. SQLMessenger can help you easily achieve these functions. Here are the detailed steps.

September 05, 2024

Send Reminder to Employees When Tasks Are Due

Q: Good day, I created a task distribution list. I would like to automatically send an email reminder if a task is due. The email reminder has to be the date when is due. The deadline or due date would be in Column C. The data is in an Excel table. Thank you in advance.

A: Yes. You can use the "Task Reminder" program in SQLMessenger to achieve this functionality.

September 04, 2024

Auto Start SQLMessenger when the System Starts Up

After SQLMessenger is installed, it does not start automatically. You can configure it to start automatically with the operating system in the System Settings dialog.

August 19, 2024

Using Task Schedules

In SQLMessenger, you can configure Task Schedules to specify when the system should automatically start the task. You can configure multiple schedules for a task to start it at different times.

June 26, 2024

Demo Task - Email Distribution

This task is used to distribute the records in an Excel spreadsheet to each recipient. You can edit the email subject and body in the Excel spreadsheet, and then SQLMessenger will send the emails to the recipients.

June 23, 2024

Demo Task - Sales Report Distribution

To assist you in understanding the configuration method for the information distribution function of SQLMessenger, after the system installation is complete, you can find a task named "(Demo) Sales Report Distribution" on the MainPage.

June 23, 2024

Using Data Import Commands

In SQLMessenger, you can use the Data Import Command to import data from an Excel file into a specified database table when the task is starting. The task will continue to execute after the data has been successfully imported.

June 05, 2024

Using Variables in Tasks

To enhance the flexibility of tasks, SQLMessenger supports the use of variables within tasks. For example, you can utilize variables to change email subjects, email body content, recipient email addresses, and query conditions in SQL statements during task execution.

June 05, 2024

Designing Body Template

You can design the email body template in the task editor. The system will generate the email body based on the template you designed. In an Interactive Query task, the body template will be displayed on the interface as a query result. The body templates for "HTML Email" and "Interactive Query" tasks can incorporate text, tables, charts, and images, while the body template for "Text Email" tasks is restricted to text content only.

June 05, 2024

Using Simple Tables

In SQLMessenger, you can easily convert the query result of an SQL statement into a table that can be sent as an attachment file in an email, or convert the query result into an HTML table to display in the body of an email. This kind of table is referred to as a Simple Table.

June 05, 2024