topic Dynamically send email in QlikView

Dynamically send email

Tue, 27 Mar 2012 08:17:46 GMT

How to write a macro to send an email to all email ids in a email ids field in the table object when it satisfies a particular condition???

Dynamically send email

fosuzuki — Tue, 27 Mar 2012 21:52:33 GMT

Have you considered using Alerts? It is possible to use an expression to get the recipients from a field, and you can configure the condition to trigger the alert.

Regards,

Fernando

Dynamically send email

Fri, 06 Apr 2012 04:53:21 GMT

Can you provide me an example???

Dynamically send email

Jason_Michaelides — Fri, 06 Apr 2012 07:03:42 GMT

I think alerts are only available if you have Publisher. If not you have to use a macro.

Dynamically send email

Fri, 06 Apr 2012 10:37:13 GMT

Can u please share code for macros

Re: Dynamically send email

Fri, 06 Apr 2012 11:50:52 GMT

Hi Sumit,

Please see the attached sample file and Image.

This is how you want.

Follow the settings like in the image.

and go to the Alerts wizard in the application and do changes.

Let me know whether it works for you or not.

Regards

....

Dynamically send email

Thu, 12 Apr 2012 06:26:42 GMT

now my question is

suppose I have table which has fields Daycompleted,Employeeid,EmailId,Whenever any employee complete a 30 days in an office,an email should go to that particular email id..

i have any answer please help me out..

Re: Dynamically send email

Thu, 12 Apr 2012 08:57:54 GMT

Hi Sumitth,

Please check the latest attachment

I think your needed like this.(Don't forget to give Mail settings.)

reply me if it is fine.

Regards

.....................

Re: Dynamically send email

Thu, 12 Apr 2012 09:03:33 GMT

I will let u knw ,if its works fine.

Re: Dynamically send email

Thu, 12 Apr 2012 09:08:36 GMT

Hi Sumitth,

Please see the latest attachment.(Provide Mail settings)

In the previous one i provide 2 buttons to complete the action how you need(for clear understanding)

In this straightaway i am providing all the actions in a single button.

Hope it will help you..

reply me if it really helps you.

Regards

.............

Re: Dynamically send email

Thu, 12 Apr 2012 09:34:26 GMT

It really works fine...

Thank u for ur support

Re: Dynamically send email

Thu, 12 Apr 2012 09:54:27 GMT

It is possible that without clicking on go button the mail is send to the require employee dynamically after every 30 days as per his joining date

Dynamically send email

Thu, 12 Apr 2012 10:29:25 GMT

Hi Rav

I have totally saved down your file to have a look at , but when I trigger the macro to run , it does not send the mails

( in my user preferences I have it set correctly ( as the test mail sends) and I have changed the employee mail addresses to my own)

Yet when I press Go>> nothing happens ( as in - it does deselect accordingly but not send mail !!)

Can you please help as Id love to be able to use this

Thanks

Re: Dynamically send email

Thu, 12 Apr 2012 10:50:52 GMT

Sumitth,

Yes you can schedule(through windows scheduling) that file if you put all the actions which are available in button in "OnOpen" sheet trigger.

What the scheduler will do is it will open and reload and save your app.

I need to work on as per joining date after every 30 days mail sending.

Regards

............

Re: Dynamically send email

Thu, 12 Apr 2012 11:01:53 GMT

Hello Bloss,

if you want to send the emails to personel mails like gmail,yahoo.............

You need to provide the correct server address and portno.

If suppose an employee who is working in a company and the company might tie up with yahoo for using thier server

Yahoo will provide a particular serveraddress(eg:smtp.bizmail.yahoo.com,etc) and respective portno(eg:20,etc)

If you provide these details the mail will approach the server and authenticate there and finally it will sent.

So, please check the details once again.

Regards

....................

Re: Dynamically send email

Thu, 12 Apr 2012 11:23:04 GMT

i gone to document setting->trigger->Onopen->edit action...

there i have put all action that was used inside button.

after opening the alertmail.qvw it select the person to whom he has to send mail but it does'nt send it.

I am attaching qvw also for u..

Dynamically send email

Thu, 12 Apr 2012 11:54:33 GMT

Hi Rav

Thanks for response

I was testing using my own mail address in the employee info.

See screen shots I have my portal info in user preference and when I test from there I receive the mail, but when I press the button on the sheet I do not receive the mail

Am I missing something ?

Thanks

Re: Dynamically send email

Thu, 12 Apr 2012 11:54:42 GMT

Summith,

Now check the attachment i have modified your file.

You used fieldevent triggers also that is why you faced the problem.

Don't need those triggers.

Regards

................

Re: Dynamically send email

Thu, 12 Apr 2012 12:07:13 GMT

Hi Bloss,

See the attached image and follow the settings like that.

As per your screen shots you miss your UserID and Password fields.

Hope it helps you.

Regards

..............

Dynamically send email

Thu, 12 Apr 2012 12:18:53 GMT

Hey Rav,

See the test mail works from the user preferences ( I have XXX over the company name in the screen shots)

All the mails which I want to send is to

anne.e.duffy@123( which is the address as set in the script) .ie

The server address is

smtp.123.pri

Not sure if there was somewhere else that I also needed to change

Apologies for not getting this

Thanks