topic Re: Is it possible in Email Body HTML type of text ? in QlikView

Is it possible in Email Body HTML type of text ?

Sat, 03 Jan 2015 07:38:41 GMT

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

Re: Is it possible in Email Body HTML type of text ?

francoiscave — Sat, 03 Jan 2015 14:28:07 GMT

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

Re: Is it possible in Email Body HTML type of text ?

Mon, 05 Jan 2015 07:36:21 GMT

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

Re: Is it possible in Email Body HTML type of text ?

vikasmahajan — Mon, 05 Jan 2015 07:46:10 GMT

What will be contents ?

Vikas

Re: Is it possible in Email Body HTML type of text ?

martin_dideriks — Mon, 05 Jan 2015 08:01:14 GMT

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