Sending Email with Excel as attachment fails when exceeds size limit

[vikramv]

Hi,

I am facing an issue in sending the excel file as attachment using macro.

It is working fine for sending email to multiple users if size is less than 1 MB but fails to send email when it exceeds this size.

Any suggestions, Do I need to change any settings in the Qlikview server ?

Thanks.

[avinashelite]

Hi Vikram,

In Qlikview we cannot send a file which is more than 1 MB, you need to contact your support team and enhance the size limit.

Instead of using macro you can go with NPrinting it handles the exporting of Qlikview objects  to different formats like word, excel, image etc and through which you can automate the process of sending email, on a schedule basis it picks the data from Qlikview dashboard and sends the mail to concerned recipients