Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Dynamic field by macro

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.

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Dynamic field by macro

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

Highlighted
Not applicable

Re: Dynamic field by macro

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.

Highlighted
Not applicable

Re: Dynamic field by macro

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