How to Automatically Send Password-Protected PDF Invoices with SQLMessenger's AttachmentMailerTool

This guide shows how to automate the process of emailing personalized, password-protected PDF invoices to clients using SQLMessenger's AttachmentMailerTool. You'll learn how to prepare a dynamic recipient list in Excel, configure security options like admin and open passwords, and send each invoice individually with custom subject lines and email content. Perfect for teams looking to streamline secure invoice distribution at scale.

June 27, 2025

How to Upgrade SQLMessenger to the Latest Version

March 31, 2025

How To Build an Order Monitoring System Using SQLMessenger

I have many orders stored in my CRM database. I need to frequently (possibly daily or weekly) query the orders that are about to expire and send them to different people for handling. Different orders need to be sent to different people. How should I build an order monitoring system to automate this task?

January 15, 2025

Sending Messages to Slack Workspace Members via Slack API

SQLMessenger version 2.1 and above allows you to send messages (such as text messages, images, files, etc.) to your Slack workspace members via the Slack API. This article will guide you on how to configure a Slack API Sender in SQLMessenger.

January 15, 2025

Automatically import Excel attachments into a local database when an email is received

I want to automatically import Excel spreadsheets sent to me by colleagues via Email into my SQL Server or PostgreSQL database. How should I do it?

Yes. Here's an interesting demonstration that shows how to import data from an Excel attachment in an email into a database and then reply to the sender with an email informing them of the number of records imported. You can also customize this demonstration to meet your specific needs.

January 15, 2025

Insert Excel Tables and Charts into Email Body

Q: I have an Excel report. I want to display the report and its charts in the body of an email. How can I achieve this?

A: You can insert this table into the body template in SQLMessenger.

September 15, 2024

How to send emails to different recipients based on the date

Q: I have a duty engineer roster like the one below. I want to send system alert messages to the engineer on duty for each day based on the date. For example, send alert emails to Liam on Monday, to Noah on Tuesday, and so on. How should I configure this?

A: You can use the "Variable Recipient" of SQLMessenger to accomplish this task.

September 06, 2024

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