I have a completed Excel spreadsheet (such as the one below). Can I display this spreadsheet in the body of an email? How can I do this?
Yes, you can use SQLMessenger to convert the Excel spreadsheet into an HTML table and display it in the body of an email. Note that these methods require Office 2010 or a later version installed on your computer.
Method 1: Insert the Excel spreadsheet into the email body when configuring the email body template. This method is suitable for displaying simple Excel spreadsheets in the email body, processes quickly, but does not support formulas and other content within the spreadsheet. On the email body template configuration toolbar, click the "Insert Pre-Designed Table" button, then select the Excel spreadsheet file you want to insert. The system will convert the contents of the first sheet of the spreadsheet file into HTML format and then insert it at the current location in the body template.
Select the Excel spreadsheet file you want to insert
The system then converts the contents of the first sheet into HTML and displays it in the email body
You can fine-tune the table contents in the body template, but please note that the SQLMessenger body editor does not directly support modifications to table or chart styles. Should the size, position, or column width of the converted table not align with your requirements, simply delete the table from the body template, adjust the format in Excel, and re-import it. You can also directly modify the HTML code of the template in the body template editor to adjust the format.
Edit the HTML code in the body template editor
Method 2: Add a "Customize Spreadsheet Template" type attachment template to the task, and the system will display the content of the attached spreadsheet in the email body during task execution. This method is suitable for handling tables with formulas or pivot tables. Due to the required format conversion during task execution, the processing speed is relatively slower.
Add a "Customize Spreadsheet Template" type attachment template to the task
If the answers provided above do not resolve your issue, please contact us, and we will offer further solutions tailored to your needs.