Send an EMail with an attachment!!

[#1]

Hi All, We are using QV 9.0. I have an application after reload exports TWO STRAIGHT TABLE chart into two different .CSV files. We have a requirement where I need to sned this files to the list of email ID's given. I was able to send a test mail and simple mail through ALERTS but was not successful sending tan email with an attachment having this two files. We don't have publisher. So if anybody can help me with the macro for the same will be helpful and great.                                                                                                                                                                                                                                                                                       Thanks In advance.        JIgesh

[Miguel_Angel_Baeyens]

Hi Jigesh,

Did you check this thread and this other thread in regards to create a macro to send reports by email?

Hope that helps.

Miguel

[#3]

how to fix this trouble？

ActiveX component can't create object 'CDO.Message'

[#4]

Hi Miguel, I have already been through this posts earlier but was not able to understand as I am new to amcros am trying my level best. I already have a trigger which creates two excel files  ON POST RELOAD trigger. but now i would like to send those files as an email attachment.                                                                           If you or anyone can help me with this we don't have publisher so the only way which I can think of is through macro's.     Thanks for the info and help.

[rwunderlich]

Macros cannot run OnPostReload. You'll have to find another way to trigger your macro.

-Rob

[#6]

Send mail : http://community.qlik.com/message/160894

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

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

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