E-Mail to all participants

More
5 years 1 month ago - 5 years 1 month ago #85418 by thommy
thommy created the topic: E-Mail to all participants
Hi there,

i am looking for an opportunity to send an e-mail to all entries in my token table, regardless of their status.

This email should work as a sort thank you email for those who already participated and simultanioulsy as a remidner for those who haven't filled in the survey yet. If you want a reminder email but for everyone.

Using the confirm function is no opportunity because every participant should receive
the same email.

Thank a lot for your answers!!!

Kind regards,
Thomas

Version 1.92+ Build 120801
Last Edit: 5 years 1 month ago by thommy. Reason: falsch platziert

Please Log in to join the conversation.

More
5 years 1 month ago - 5 years 1 month ago #85514 by Mazi
Mazi replied the topic: E-Mail to all participants
There is no inbuild feature for this, but you can try the following, assuming you have direct DB access:

- Set all used tokens to "not used". SQL is like "update lime_tokens_12345 set completed='N' where completed != 'N'" (this is not tested!)

- Overwork the email invitation message according to your needs.

- Send the email invitation, everyone should receive that email now.

- Re-set the completed flag. SQL: "update lime_tokens_12345 set completed = 'Y' where uses_left >0".

^- The "uses_left" value will be >0 for everyone who has completed the survey so this way we can re-add the completed information.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
Last Edit: 5 years 1 month ago by Mazi. Reason: wrong DB table name

Please Log in to join the conversation.

More
5 years 1 month ago #85544 by DenisChenu
DenisChenu replied the topic: E-Mail to all participants

Mazi wrote: - Re-set the completed flag. SQL: "update lime_tokens_12345 set completed = 'Y' where uses_left >0".

^- The "uses_left" value will be >0 for everyone who has completed the survey so this way we can re-add the completed information.

- uses_left < 1 for completed survey ....
- uses_left > 0 for non completed survey ....

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now