topic Re: VB Macro to create e-mail from HTML file in QlikView

VB Macro to create e-mail from HTML file

h_demarco — Wed, 03 Aug 2016 20:09:33 GMT

Dear helpers,

I have a macro to create e-mail and send few charts to company stakeholders. My intention is to use HTML file emailrep.html as a default for body. This HTML file has more than 400 lines, so it is hard to convert it to a string using "& _" in the end of each line.

Pasting HTML code into Qlikview macro creates syntax error.

Set MyOlApp = CreateObject("Outlook.Application")
Set myItem = MyOlApp.CreateItem(olMailItem)

htmlfile = "Qlikview\emailrep.html"

With myItem
    .To = Email.Item(i).Text
    .BodyFormat = 2
    .Subject = "Sales Report - " & Field.Item(i).Text
    .HTMLBody = htmlfile
    .Attachments.Add ("Report.pdf")
    .Display
End With

Does anyone know how to get HTML file and use as e-mail body with this circumstances?

The use of Outlook is not mandatory. Just developed because it is easier for me.

Re: VB Macro to create e-mail from HTML file

marcus_sommer — Wed, 03 Aug 2016 20:27:14 GMT

I think you need to pass the html as string and not as a reference to a file (and it must be an absolute path and not a relative one) - have a look on these (similar) example: Re: Exportar varias tablas a un archivo html.

- Marcus

Re: VB Macro to create e-mail from HTML file

h_demarco — Thu, 04 Aug 2016 21:13:53 GMT

Marcus,

I changed from Outlook to CDO object. Using CreateMHTMLBody method did exactly what I was looking for.

So, thank you much. I own you a beer.

Henrique