Sending QV object by e-mail using Macro

[linoyel]

Hey all,

I need your help in Macro issue.

I need an e-mail with a QV document certain objects to be sent daily.

I understand it's possible to write Marco that does it, but the only option with examples I've found meanwhile is creating a button that runs Macro. This is not a good solution in my case, cause I need the e-mail to be sent every day automatically (by schedule), without waiting that someone will press the button to send an e-mail...

Is there an outside-of-Qliqview option to write a VB script for sending e-mails?

If there is, please give me some examples to implement this (I have no idea of writing Macros..)

Thank you!

[linoyel]

It seems to me we're getting closer

How do I export objects to a folder and how do I do it only once a day?...

[fkeuroglian]

Hi Linoy

i attach an example to export the object to a root folder in a pdf format.

[arsal_90]

Hi Fernando

Your work is awesome. But i have to ask one question can u elaborate Make Pdf is making pdf in which root drive. You mention C:\ but i can't find it there

Thanks & regards

Arsalan

[fkeuroglian]

Hi Muhammad, im glad that help you the document.

you can modified the root, by defect i put C: but you can change it in the edit module.

if your pdf doesnt create, please check that the option (i attached an image) are the same i show you

you have to allow acces to your sistem to write in c(or in another local disk)

please tell me if you need something

Fernando

[arsal_90]

Hi Fernando

I change the root folder from C:\ to D:\. But it not save any pdf can u tell me which part of macro is saving PDF as i understand it's printRP01.

Find the attached pic

[arsal_90]

Hi Fernando

I change the root folder from C:\ to D:\. But it not save any pdf can u tell me which part of macro is saving PDF as i understand it's printRP01.

Find the attached pic

[fkeuroglian]

Muhammad

this sub is who save pdf

sub printRP01

printReportPDF "C:\18T.pdf"

ActiveDocument.GetApplication.Sleep 2000

ActiveDocument.PrintReport "RP01", "QlikViewPDF",False

ActiveDocument.GetApplication.Sleep 10000

end sub

in the example do not create you?

could you change the option that i put in the attached picture?

give me a print screen about your EDIT MODULE

[arsal_90]

Fernando

Have you find the image and i also allow system access

[arsal_90]

Hi Fernando

Have u checked the image.

[fkeuroglian]

Muhammad

i add to the example some new thing that let you export to JPG, could be that a permission an security problem and i want to know if you can export to jpg

if you can export , that means that you have the correct permision and security setings, and the problem is something  the pdf editor and save.

tell me what happend

good luck

press the button IMG