Is it possible in Email Body HTML type of text ? - Qlik Community

Report Inappropriate Content · ‎2015-01-03

Hi Forums/Friends,

Wish you all Happy New Year 2015.

I had got one requirment which is as follows.

I had done mailing configuration. Which is working fine.

But in email body I want HTML type of text instead of Plain type of text.

Is it possible?. If Yes.

Can anybody please show the step to achieve it. I am struck here.

Advance Thanks

SD

francoiscave · ‎2015-01-03

Hi Shan,

Do you mean that you use Alerts Tools ?

In this case, HTML type is not possible.

You can use the NPrinting softwar to do that.

BR,

François

Report Inappropriate Content · ‎2015-01-05

Hi BR,

Not from Alerts Tools, By creating Macro.

FYI. I want the HTML body contains should be dyanmic.

Please help to achieve it.

Advacne Thanks

SD

vikasmahajan · ‎2015-01-05

What will be contents ?

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.

martin_dideriks · ‎2015-01-05

You can change you macro to use the parts of the code below.

Everything has to be written in HTML. In the example below I have a text in a variable named MailBody - in this i replace all linefeeds (chr(10)) with <br>.

objMessage.Subject = ""& doc.GetSheetObject("TX_Subject").GetText &"" 'Get Subject from textobject

objMessage.To = "testme@mydomain.com"

objMessage.HtmlBody = "<font size=2 face="& chr(34) & "verdana"& chr(34) & ">" & replace(MailBody,chr(10),"<br>")

objMessage.Send

Hope it helps.

//Martin