Variable Month in E-Mail Subject and Text

[olenedderhoff]

I am sending out a weekly Report via the Reporting Service and want to include the current month inside of the title and text of the Mail. Is there any automated way of doing this like:

Bonus Report <Month>?

[F_B]

Hi @olenedderhoff ,

are you sending reports using Subscription, Tabular Reporting or Appllication Automation?

[olenedderhoff]

I am using tabular reporting via the Excel Add-In and create the Report in the Reporting Section of my App.

[diegozecchini]

Hi!
You can create a variable, e.g., vCurrentMonth, and set its expression to display the current month dynamically. You can use Date(Today(), 'MMMM') to get the current month in full name (e.g., "October").

Then when configuring the email subject or body in your Reporting Section, you can reference the variable you created:

In the subject line of the report, include $(vCurrentMonth) where you want the month to appear. For example:

Bonus Report $(vCurrentMonth)
This will automatically replace $(vCurrentMonth) with the current month name in both the subject line and body of the email when the report is sent.

Run a test to ensure that $(vCurrentMonth) correctly resolves to the current month. This should now automatically update every time the report is generated.

[olenedderhoff]

With these Setups:

let vCurrentMonth = Date(Today(), 'MMMM');

I unfortunately get this result in the Mail:

So this approach does not work.

[Lech_Miszkiewicz]

Hi @olenedderhoff 

There is no way to currently get variables into email subject and text when using Tabular Reporting solution for now.

Sorry

cheers