Welcome, Guest
Username: Password: Remember me

TOPIC: E-Mail to all participants

E-Mail to all participants 2 years 1 month ago #85418

  • thommy
  • thommy's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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: 2 years 1 month ago by thommy. Reason: falsch platziert
The administrator has disabled public write access.

Re: E-Mail to all participants 2 years 1 month ago #85514

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5333
  • Thank you received: 296
  • Karma: 249
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)limesurvey.org'"
Last Edit: 2 years 1 month ago by Mazi. Reason: wrong DB table name
The administrator has disabled public write access.

Re: E-Mail to all participants 2 years 1 month ago #85544

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6451
  • Thank you received: 844
  • Karma: 249
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 ....
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.103 seconds
Donation Image