Qlikview Macro

[bindu_apte]

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]

might be helpful for you?

Useful Qlikview Macros

[vikasmahajan]

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

vikas

[bindu_apte]

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&_