Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Qlikview Macro

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

3 Replies
Highlighted
Champion
Champion

might be helpful for you?

Useful Qlikview Macros

Highlighted
Champion
Champion

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

vikas

Highlighted
Creator III
Creator III

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