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
