topic Re: Qlikview Macro in QlikView

Qlikview Macro

bindu_apte — Mon, 22 Feb 2016 07:05:38 GMT

Hi,

Am trying to write qlikview macro to send an email with multiple lines.

Body of the mail should be in multiple lines.

Example:

THIS IS A SYSTEM CREATED E-MAIL. PLEASE DO NOT REPLY TO THIS MESSAGE.

Dear All,

requires your review/comments.

Details:

Submitted By : “ Drafter’s Name”

Idea ID : “ 1234”

Idea title : “ABC”

Idea status : “Current Status”

Please review and take appropriate action for further implementation.

Thanks,

Sender

Anonymous — Mon, 22 Feb 2016 08:13:23 GMT

might be helpful for you?

vikasmahajan — Mon, 22 Feb 2016 08:17:04 GMT

you can change excel interface as per your requirement and send mail through this attached QVW

vikas

bindu_apte — Mon, 22 Feb 2016 09:01:20 GMT

Hey Thanks All.

I got the solution.

We need to put the below function to go to new line.

myMessage.Body= "Dear '"&variable1&"',"&vbLf&_

"An Idea has been submitted and requires your review/comments "&vbLf&_

"----------------------------------------------------------------------------------------------------"&vbLf&_

"Details:"&vbLf&_

"Submitted By :'"&variable2&"'"&vbLf&_

"Please review and take appropriate action for further implementation."&vbLf&_