Home Docs Changelog Download Pricing Service Center Contact

Category

Automatically Fill in Excel Sheets Using SQLMessenger

In SQLMessenger, you can create an Excel template and have SQLMessenger fill the query results from SQL statements into the specified cells in the template, thereby achieving automatic filling of Excel sheets. This article introduces how to use the automatic Excel sheet filling feature through a simple example.

July 06, 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

Using Custom Excel Templates

In SQLMessenger, if the Simple Table cannot meet your requirements, you can design an Excel table according to your needs, and then SQLMessenger can fill in the SQL query results into the specified locations in the table. You can use formulas, charts, and other content in the table.

June 05, 2024

Convert Documents To PDF

In SQLMessenger, you can convert HTML documents (such as email bodies) or Excel spreadsheets generated by tasks into PDF files to send as email attachments. You can also add watermark and password for the PDF files.

June 05, 2024

Cookie Settings

We use cookies to enhance your browsing experience, serve personalized content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies in accordance with our Cookie Policy.

You can change your preferences at any time by clicking on "Cookie Settings" in the website footer.

Cookie Preferences

Manage your cookie preferences. You can enable or disable different types of cookies below. Necessary cookies cannot be disabled as they are required for the website to function properly.

Necessary Cookies

Always active

These cookies are essential for the website to function and cannot be switched off. They are usually only set in response to actions made by you such as setting your privacy preferences, logging in or filling in forms.

Preferences Cookies

Makes the site easier to use

These cookies allow the website to remember choices you make and provide enhanced, more personal features.

Analytics Cookies

Helps us improve our website

These cookies help us understand how visitors interact with our website, which helps us improve our products and services.

Marketing Cookies

Used to track visitors across websites

These cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging.