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

[vkal12]

Hi @Lech_Miszkiewicz,

as this post is already a couple of months old: do you know if there is now a way to use variables in e-mail messages? 

[Lech_Miszkiewicz]

Hi @vkal12 

It depends on your approach. 

If you are talking about email body you can workaround it by creating HTML report which can have very dynamic content and can contain variables, functions and a lot more (as it is HTML embedded report) which can serve as an email content. Currently that is the only dynamic way of controlling email content which to be fair is the same method we used in NPrinting.

cheers

[Lech_Miszkiewicz]

More about subject here: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/HTML/de...