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:

dist_email_03.png

Sometime, however, you may want a somewhat more complete email body - one that you place in the report itself, so that you can review it:

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

dist_email_04.png

Method #1 - Cell or Named Range Reference

We can use a cell reference or, if the email body is in a named cell...

dist_email_05.png

... 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:

dist_email_06.png

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

dist_email_07.png

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:

dist_email_10.png

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

dist_email_01.png

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:

dist_email_08.png

Now, when we distribute the report, no file is created. Instead, our report becomes the body of the email:

dist_email_11.png
Did this answer your question?