DEV Community

AndySqlman
AndySqlman

Posted on • Edited on

How to send PDF files to each recipient individually

Reposted from https://www.sqlmessenger.com/faqview.html?id=545

Q:How to Quickly Distribute Report Files to Each Recipient Individually

I have many report files that I need to distribute individually to my employees. Is there a quick and easy way to accomplish this task?

My report files:

Image description

The content of the email I want to send:

Image description

A: You can use the file distribution feature of SQLMessenger to help you complete this task.

  • 1 Distributing Files via Email

**Step 1: **Prepare the content to be sent in an Excel spreadsheet.

Image description

The spreadsheet should include the following columns:
Email required The employee's email address
Subject can be left blank The subject of the email
Body can be left blank The body of the email
FileName required The name of the file you want to send to this employee (including the file path)

**Note: **The data must be placed in the first sheet of the Excel workbook, starting from cell A1.

Step 2: In SQLMessenger, double-click the "(Demo) File Distribution (Via Email)" icon.

Image description

**Step 3: **Under the "Information Distribute" tab, click the "Import Recipient List" button. Then select the Excel spreadsheet you prepared and click "OK".

Image description

Step 4: Verify that the imported data is correct, then click "OK".

Image description

  • The system will start to execute the "(Demo) File Distribution (Via Email)" task, generating an email for each row in your spreadsheet.

Image description

Step 5: In "Message Review," locate the task that was just executed and click the "Task Name."

Image description

Step 6: View the email content. Once confirmed, click the "Review All" button.

Image description

Step 7: Check the "Review Passed" option and click "OK".

Image description

  • The system will start sending the emails. You can monitor the sending progress under the "Outbox" tab in the "Email & Message Manager."

Image description

2 Distributing Files via Slack

Step 1: Download the config file of the task. Click here to download (Demo)File Distribution(Via Slack).tsk

Step 2: In the Task Manager, click "Import Task," select the downloaded ".tsk" file, and click "OK".

Image description

Step 3: In the "Import Task Config" dialog, click the "(Select a Message Channel)" button in the "Message Channel List," and select a Slack app to send messages. Then click "OK" to import the task configuration into SQLMessenger.

Image description

Step 4: After the task is imported, run it in the Task Manager. The following steps are the same as those for "1 Distributing Files via Email".

Image description

  • Message and file received in Slack Image description

Note: This task uses the email addresses of Slack workspace members to query the corresponding Member ID in the local Slack workspace member list. If the email address cannot be found in the member list, the message will not be sent to the corresponding person. Therefore, please ensure that the Slack workspace member list in SQLMessenger is up to date. Click here for more information.

Reposted from https://www.sqlmessenger.com/faqview.html?id=545

Top comments (0)