Macro for e-mail

[#1]

Hi !

Can some one help me to write macro which can send email.

Thanks

[suniljain]

Pls Find Attachment of Application For Email Distribution From qlikview.

[#3]

Thanks Sunil !

I have seen this qvw.

In this application when I am clicking on send a mail it goes to "objEmail.Send" in macro writing box.

Can you please suggest where I have to make changes so that it will work on my application.

Thanks,

[suniljain]

you require persmission on SMTP server. pls check whether you properly configured your mail server setting or not.

[#5]

Hi,

I used the attached application, when I tried to send the report my application doesn't response anymore? what seems to be the problem?

what PDF writer did you use? cause when I check the path where the PDF file will be saved it's not there..

I am using PDF XChange but its only a demo version

hope you can help me on this..

Thanks!

[#6]

Hi,

I am also trying to send am mail using the macro and it also stops at step "objEmail.Send". I tried to send a mail using the same settings as in Qlikview in MS Live Mail and it works. So I guess i have the needed rights. What else can be the reason that it stops working? Is there a place where I can see WHY it stops at objEmail.Send?

Thanks,

Martin

[#7]

Hi,

no one an idea?

Martin

[#8]

problem : can't set macro to allow system access from RELOAD (option /r not work)

Ref : http://community.qlik.com/message/18973

Ref : http://community.qlik.com/message/21833

1.Create Batch file  ==> "C:\Program Files\QlikView\qv.exe" /l "path_to_document"

2.Create Task Scheduler to RUN Batch file (1)

3.QVW Document ==> Document properties > OnPostReload ==> Add RUN MACRO

4.add  (end of script)

       ActiveDocument.Save

   Application.Quit

don't forget

1. User Preference >Security > select "Module..." and "File.."

2. Document Properties > Security > Macro Override Security

[#9]

thank you verymuch ongart,

you are the only person solved the issue of running a  macro on post reload

excellent..!!!!