E mail attachment

Mon, 28 Jan 2013 11:45:36 GMT

Hi All,

Is there anybody who completes the e mail attachment as pdf in qlikview. if so please help me to send the code. I have tried but not works.

Thanks

Renjith Kumaran

Re: E mail attachment

Mon, 28 Jan 2013 12:38:48 GMT

read this:

http://community.qlik.com/thread/31509

Re: E mail attachment

Mon, 28 Jan 2013 13:35:02 GMT

thanks pari

Re: E mail attachment

Tue, 29 Jan 2013 12:35:35 GMT

Hi,

I have tried the link you sent. its creates the pdf and then fails to mail. I tried a lot, no use.

here is my mailing code

function mailrapport()

Dim objEmail

Const cdoSendUsingPort = 2 ' Send the message using SMTP

Const cdoAnonymous = 0 'Do not authenticate

Const cdoBasic = 1 'basic (clear-text) authentication

Const cdoNTLM = 2 'NTLM

SMTPServer = "smtp.live.com"

Const SMTPPort = 25 ' Port number for SMTP

Const SMTPTimeout = 60 ' Timeout for SMTP in seconds

'Sending mail

Set objEmail = CreateObject("CDO.Message")

Set objConf = objEmail.Configuration

Set objFlds = objConf.Fields

With objFlds

'---------------------------------------------------------------------

' SMTP server details

.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = cdoSendUsingPort

.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = SMTPServer

.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoAnonymous

.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = SMTPPort

.Item("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = False

.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = SMTPTimeout

.Update

'---------------------------------------------------------------------

End With

objEmail.To = "rkumaran@ustechdata.com" 'Email Recipient

objEmail.From = "renjithk@live.com" 'Email Sender

objEmail.Subject = "The name of the report" ' Subject

objEmail.TextBody = "some text in the body of the mail" 'Text Body

objEmail.AddAttachment "c:\PDFs\Operations\transactierapportPDP.pdf" ' Attachement

objEmail.Send

Set objFlds = Nothing

Set objConf = Nothing

Set objEmail = Nothing

end function

Re: E mail attachment

Wed, 30 Jan 2013 18:16:05 GMT

Please treat this as closed...

Thanks

Renjith Kumaran

topic Re: E mail attachment in QlikView

E mail attachment

Re: E mail attachment

Re: E mail attachment

Re: E mail attachment

Re: E mail attachment