Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro for e-mail

Hi !

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

Thanks

8 Replies
suniljain
Master
Master

Pls Find Attachment of Application For Email Distribution From qlikview.

Not applicable
Author

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
Master
Master

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

Not applicable
Author

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!

Not applicable
Author

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

Not applicable
Author

Hi,

no one an idea?

Martin

Not applicable
Author

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

Not applicable
Author

thank you verymuch ongart,

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

excellent..!!!!