topic Dynamic field by macro in QlikView

Dynamic field by macro

Mon, 08 Feb 2016 07:17:44 GMT

Dear All,

I want to send a mail through macro which has been done but in mail body i want to put Dealer name and their area office at top .

Consider the below format

Dealer Name,Area Office(Should be change according to dealer)

Dear Sir/Mam,

Please find your attached Crusade performance for the month of Feb-2016(Must be change on month basis).For any queries or support in improvement, please get in touch with your area office team.

Re: Dynamic field by macro

marcus_sommer — Mon, 08 Feb 2016 12:02:38 GMT

In general something like this should work:

varPeriode = month(now()) & "-" & year(now())

varBody1 = "Dealer Name,Area Office(Should be change according to dealer) Dear Sir/Mam, Please find your attached Crusade performance for the month of "

varBody2 = ".For any queries or support in improvement, please get in touch with your area office team."

varBodyComplete = varBody1 & varPeriode & varBody2

You might need some further adjustments to format the period differently (and/or to fetch this from a gui-variable) or to put linebreaks - Chr(10) - within the text.

- Marcus

Re: Dynamic field by macro

Mon, 08 Feb 2016 12:25:53 GMT

Hi Rasool,

First you have to go to settings--user preferences -- mail--give the sender and server details and then go to tools -- alerts--give the details like message which you want to send it and mail recipients etc details.

Re: Dynamic field by macro

Tue, 09 Feb 2016 06:20:13 GMT

thanx for the response will check you and confirm for the same