topic Re: Qlikview Macro code to send a Email in QlikView

Qlikview Macro code to send a Email

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

While using the below code i can able to send a e-mail from Qlikview.

Here i'm trying to do more modifications like now in mail i want to add some body content & signature for the e-mail.

While using the below marco code i can able to achieve the Blue code stuff.. but i'm not able to achieve the red code stuff ..

Help on this..

Qlikview Macro Code:

sub mSendMail

Dim objOutlk 'Outlook

Dim objMail 'Email item

Dim strMsg

dim strMailTo

dim sString

dim oldFormat

Dim Rng

Const olMailItem = 0

Const CdoReferenceTypeName = 1

Set objOutlk = CreateObject("Outlook.Application")

Set objMail = objOutlk.createitem(olMailItem)

Set Rng = Nothing

objMail.To = "abc@xyz.com"

objMail.subject = "Today Dashboard" & Date()

ActiveDocument.ActiveSheet.CopyBitmapToClipboard true

ActiveDocument.GetSheetObject("CH86").ExportBitmapToFile "C:\User\Dashobard.jpeg"

objMail.attachments.add("C:\User\Dashobard.jpeg")

objMail.body ="Please find the Today Dashboard"

strMsg = "This is an automatic generated email from QlikView for Dashobard."

objMail.body = strMsg

objMail.HTMLBODY = "<HTML><BODY><img align=baseline border=0 hspace=10 src='cid:C:\User\Dashobard.jpeg'</BODY></HTML>"

objMail.Send

Set objMail = Nothing

Set objOutlk = Nothing

'Msgbox " Mail delivered"

end sub

Expected output in the E-mail

To:abc@xyz.com

CC:cdf@xyz.com

Subject: todays dashboard.

E-mail body : Hi, Please find the todays dashboard in the attachments.

IMAGE

Email-Signature
Thanks & Regards,

Venkata Sreekanth

Re: Qlikview Macro code to send a Email

marcus_sommer — Fri, 09 Feb 2018 07:56:42 GMT

I think the problem are the multiple and contrary definings of the mail-body - there are 3 different ones. I suggest to use only one statement like: objMail.HTMLBODY = strMsg whereby your variable then contained the whole body-statement including your needed html-tags and the references to the linked pictures (this path must be available from a receiver point of view and therefore you might any network-path for it and not the local C:).

If and how you could access/choose the proper signature there are outlook-communities a better source whereby you could also set them semi-static with some fix text and variable values from the user who called the routine.

I think this link might be helpful to understand how the HTMLBody could be filled: Send Mail from QlikView with table in the mail body.

- Marcus

Re: Qlikview Macro code to send a Email

Anonymous — Fri, 09 Feb 2018 08:06:10 GMT

Hi Sommer,

Thanks for reply. Yes i agree, i have used this code objMail.HTMLBODY = strMsg cod in my macro. But the problem here is when i received the mail, the body content is not appearing.

Can you suggest me the macro code to get that e-mail body(3) consists the testmessage, Imge & singature.

Thanks in advance..

Thanks & Regards,

Venkata Sreekanth

Re: Qlikview Macro code to send a Email

marcus_sommer — Fri, 09 Feb 2018 08:26:19 GMT

Had you checked that your variable has really this content which you expect and that there was only one body-statement and that the html has a valid syntax?

- Marcus

Re: Qlikview Macro code to send a Email

Anonymous — Fri, 09 Feb 2018 08:29:30 GMT

Its working properly, but in my generated mail dont have the body content. It is showing only the image

Re: Qlikview Macro code to send a Email

marcus_sommer — Fri, 09 Feb 2018 08:32:52 GMT

What is the content of the variable strMsg?

- Marcus

Re: Qlikview Macro code to send a Email

Anonymous — Fri, 09 Feb 2018 10:55:42 GMT

strMsg = "This is an automatic generated email from QlikView for Dashobard."

Re: Qlikview Macro code to send a Email

marcus_sommer — Fri, 09 Feb 2018 11:15:23 GMT

It looked that you yet use several body-statements but it must be only one - maybe something like this:

strMsg = "<HTML><BODY><div>This is an automatic generated email from QlikView for Dashobard.</div><br><br><img align=baseline border=0 hspace=10 src='cid:C:\User\Dashobard.jpeg'</img></BODY></HTML>"

objMail.HTMLBODY = strMsg

- Marcus

Re: Qlikview Macro code to send a Email

Anonymous — Fri, 09 Feb 2018 11:47:18 GMT

Hi Sommer,

Its working now. I cannot able to see the image. As below below like that i can able to see the image in mail body.

I want to view the full image in mail body it self without clicking on the attachments.

Re: Qlikview Macro code to send a Email

marcus_sommer — Fri, 09 Feb 2018 12:08:28 GMT

You need to enable the option to view your mails in html and also to load pictures automatically - if both is set the picture should be displayed. If not there might be an syntax-error - I suggest to look into various html and outlook communities how a valid syntax looks like - and to make sure that the path to the picture is available from outlook.

- Marcus

Re: Qlikview Macro code to send a Email

INRHA — Wed, 07 Oct 2020 00:24:03 GMT

It is a very old post but I hope it helps someone, this syntax work for me:

objMail.HTMLBODY = "<HTML><BODY><p align='CENTER'><img src='C:\User\Dashobard.jpeg' width=600 height=450 border=0><br></p></BODY></HTML>"

All the body must be in HTML code so remove objMail.body

Re: Qlikview Macro code to send a Email

olaoyesunday1 — Tue, 19 Mar 2024 17:02:02 GMT

Please, How did you set up Outlook SMTP in your QlikView?