Using a cell or range reference for the Email Body in a Distribution List
Created by Damien Zwillinger, Modified on Tue, 05 Sep 2023 at 12:34 AM by Damien Zwillinger
Applies to:
- Velixo Classic
- Acumatica, MYOB, Cegid
Overview
When creating a new Distribution List for which you want to send an email, you have the option to type in the text you want to use for the body of your email:

Velixo Reports allow you to do that and then reference that in the Email Body column of the Distribution List.

Method #1 - Cell or Named Range Reference
We can use a cell reference or, if the email body is in a named cell...

... we can use that.
On the Distribution List tab, we enter a # symbol in the Email Body column and then specify the cell or range reference of the text we want to use:

When we distribute, our email is created with the text we placed in our report and the specified report is attached:

Troubleshooting:
In order to maintain the line spacing in your email body, you MUST use the # symbol when referencing the cell or range. Using an equal sign (=), for example, will result in all line spacing being removed:

Method #2 - Use the report as the email body (with no attachment)
Sometimes, we may want to use the report itself as the body of our email and not even include an attachment.
Our data is on the Report sheet in columns C through E:

To accomplish this, Velixo Reports includes the None distribution format:

By selecting None and then leaving the File Name, Tab Selection, and Folder Path blank, we can then use a reference (to a cell, cell range, or named range) in the Email Body column to point to our report data:

Now, when we distribute the report, no file is created. Instead, our report becomes the body of the email:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article