Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bindu_apte
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
Anonymous
Not applicable

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
bindu_apte
Creator III
Creator III
Author

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