Welcome, Guest
Username: Password: Remember me

TOPIC: E-Mail to all participants

E-Mail to all participants 1 year 7 months 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: 1 year 7 months ago by thommy. Reason: falsch platziert
The administrator has disabled public write access.

Re: E-Mail to all participants 1 year 7 months ago #85514

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5275
  • Thank you received: 289
  • Karma: 246
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: 1 year 7 months ago by Mazi. Reason: wrong DB table name
The administrator has disabled public write access.

Re: E-Mail to all participants 1 year 7 months ago #85544

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 5830
  • Thank you received: 711
  • Karma: 220
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.142 seconds
Donation Image