Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
might be helpful for you?
you can change excel interface as per your requirement and send mail through this attached QVW
vikas
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&_