Email macro for Salutation

Mon, 25 Jul 2016 15:28:33 GMT

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

topic Email macro for Salutation in QlikView

Email macro for Salutation