Using a cell or range reference for the Email Body in a Distribution List

Created by Damien Zwillinger, Modified on Fri, 12 Apr 2024 at 06:27 PM by Harry Lewis

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:

 

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

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

 

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.

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article