DEV Community

Cover image for How to insert Excel tables and charts into email body
AndySqlman
AndySqlman

Posted on • Edited on

How to insert Excel tables and charts into email body

Reposted From: https://www.sqlmessenger.com/docreader.html?id=562

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?

  • My Excel report Image description

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

  • Note: This feature requires Excel 2010 or later to be installed on your computer.

Step 1: Create an email task in SQLMessenger and fill in the subject and recipients.

  • Create an email task in SQLMessenger

Image description

  • Enter the email subject and select recipients

Image description

Step 2: Enter the text content of the email to be sent in the body template. Then, move the cursor to the location where you want to insert the Excel report and click the "Insert Pre-Designed Table" button on the toolbar.

  • Enter the text content of the email, click the "Insert Pre-Designed Table" button

Image description

  • Select the Excel file to insert into the body and click "OK"

Image description

  • At this point, SQLMessenger will insert the Excel table into the location you specified.

Image description

  • After editing the body, click the "Deploy" button

Image description

Step 3: Run the task, the system will generate and send the email to the recipients.

  • Run the task in Task Manager
    Image description

  • At this point, the system will generate the email and send it to the recipients.

  • The email received by the recipient

Image description

FAQ

Q: Can the body be converted to PDF and sent?

A: Yes. SQLMessenger can convert the body to a PDF file and send it. Additionally, it can add watermarks and passwords to the PDF file.

Related Document: Convert Documents To PDF

  • Convert the body to a PDF file for sending Image description

Top comments (0)