Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamically send email

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???

37 Replies
Not applicable
Author

It really works fine...

Thank u for ur support

Not applicable
Author

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

Not applicable
Author

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

A

Not applicable
Author

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

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

Not applicable
Author

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

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

Not applicable
Author

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..

Not applicable
Author

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

email test.bmp

Not applicable
Author

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

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

Not applicable
Author

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

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

Not applicable
Author

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


A