topic Re: using macro to send email with attachments in QlikView

using macro to send email with attachments

idogridish2 — Tue, 02 Feb 2016 09:33:16 GMT

hello everyone,

i am new to qlikview and i want to send an email by macro function

with attachment of a csv file that allready exists on my computer.

i have a simple macro in excel and it works fine.

i want to call the function in the end of my qvw script.

here is my excel macro function:

Sub Mail_Outlook()

Dim OutApp As Object

Dim OutMail As Object

'Send Mail

Set OutApp = CreateObject("Outlook.Application")

Set OutMail = OutApp.CreateItem(o)

With OutMail

.Subject = MailSubject

.body = MailBody

.Attachments.Add "D:\ex1.xlsx"

'.Display

.Send

End With

Set OutMail = Nothing

Set OutApp = Nothing

End Sub

please help.

best regards to all and thanks in advence.

Anonymous — Tue, 02 Feb 2016 10:32:14 GMT

Did you check this?

idogridish2 — Tue, 02 Feb 2016 12:26:08 GMT

hi balrajahlawat yes i have checked those forums.

all i want is a simple code like i wrote for excel above.

thank you.

Colin-Albert — Tue, 02 Feb 2016 12:28:07 GMT

The other option is to look at NPrinting, the desktop version can do this without the need for macros.