topic Re: Need Code for Macros to send an EMAIL in QlikView

Need Code for Macros to send an EMAIL

Thu, 15 Nov 2012 19:26:13 GMT

Can anyone post the code for sending an emil trough macros......

Re: Need Code for Macros to send an EMAIL

Gysbert_Wassenaar — Thu, 15 Nov 2012 19:30:52 GMT

See here or here

Re: Need Code for Macros to send an EMAIL

Thu, 15 Nov 2012 19:56:19 GMT

Thanks Gysbert,

I am using the code from second link, but I am not getting any email......Can you please check my qvw attached....I gave trigger that macro on post reload....

Re: Need Code for Macros to send an EMAIL

Thu, 15 Nov 2012 20:01:53 GMT

I am getting an error as Activex componet cannot creat an object...in the second line of macros....

Re: Need Code for Macros to send an EMAIL

Thu, 15 Nov 2012 20:41:16 GMT

Did you check your security settings?

Edit Module:

Re: Need Code for Macros to send an EMAIL

Thu, 15 Nov 2012 20:51:25 GMT

I did not change those settings, Now I did but still its not working....Should I give my email id settings in user preferences...mail tab.....if so wat I am supposed to give in server address position.........

this is my error

The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available

Re: Need Code for Macros to send an EMAIL

Thu, 15 Nov 2012 23:46:23 GMT

Dear ,

Kindly find the attachment.

but you need to goto Edit Module and enter your email id and destination email id then click on email button it will send the email to the specified account.

i hope this one will help you,

thanks,

Mukram

Re: Need Code for Macros to send an EMAIL

Fri, 16 Nov 2012 15:38:39 GMT

hello Mukram,

I am getting an error

The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not available

I am getting a popup saying Exported but I am not receiving any mail.....

Re: Need Code for Macros to send an EMAIL

whiteline — Fri, 16 Nov 2012 18:53:57 GMT

http://support.microsoft.com/kb/942495/eng

Re: Need Code for Macros to send an EMAIL

sanketkhunte — Fri, 19 Apr 2013 11:59:57 GMT

Hi Mukram,

Ur file is too much helpful to me.Thank you so much.

Here I am getting an error when I am clicked on "Email" button it Exported Image perfectly but then

after 1 or 1.5 mins. it will go in processing and suddenly gives me Macro window.

Will you please tell me why this happend ; do I required to do some setting if yes please tell me.

Your help will appriciate me.

Here I have also attached QV file.

Please see attached file.

Regards

Sanket.