Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Email macro for Salutation

Hi,

I'm new to Qlikview macros and wondered how I can change the salutation on a email macro I have depending on the time of day i.e. Good Morning or Good Afternoon.

The body variable starts - strbody = "<font size=""3"" face=""Calibri"">" & "Morning,<br>    so where it says Morning, I would like to put in another variable created earlier in the code to state Morning or Afternoon.

This is how I would do it in Excel

Select Case Time

  Case Is < TimeValue("12:00")

  msg = "Good morning "

  Case Is < TimeValue("16:00")

  msg = "Good afternoon "

  Case Else

  msg = "Good evening "

  End Select

Thanks in advance

Labels (1)
0 Replies