Send email only to those where i had error sending emails.

52 views
Skip to first unread message

Abhinav Singh

unread,
Jun 8, 2021, 12:46:36 PM6/8/21
to NV Autocrat Add-on
Screenshot (594).pngHello
So, I organized a online competition via google forms and sent participants certificates via autocrat. Many of the participants didn't received certificates because either they submitted wrong email ID or i consumed the daily free email quota. Now many of the participants have corrected their email ID by editing their response.

Now, how can i send email only to those where i had error sending emails, and also automatically update the status of the email (sent or not sent)

Joseph Schmidt

unread,
Jun 8, 2021, 8:40:26 PM6/8/21
to nv-autocr...@googlegroups.com
Delete the information from the status column and run Autocrat again.



--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/a585a8a9-10ef-4c1e-8ea0-37d272382b2en%40googlegroups.com.

Shannon Richardson

unread,
Jun 9, 2021, 12:00:27 PM6/9/21
to NV Autocrat Add-on
  I did.  Three times, and triple checked my set up, as well, to make sure nothing was off with that.  Same result.  

Abhinav Singh

unread,
Jun 9, 2021, 10:46:17 PM6/9/21
to nv-autocr...@googlegroups.com
Should i delete all the info in status column or only those entries where status shows :  Failed to send mail

You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/bJO5oqyhWvg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOQfKGVRzYCZ71mgL0HYh50eTOavfyz4gwCF4%2BLARb_ZoA%40mail.gmail.com.

Shannon Richardson

unread,
Jun 9, 2021, 10:52:06 PM6/9/21
to nv-autocr...@googlegroups.com
You can do either just the entries for the ones with errors or back up your sheet, copy it, and in the copy just play Werth the ones giving you errors. If you have over 240 lines on your spreadsheet,  that could also be the problem. So backing up and reducing the number of entries may help. 

Joseph Schmidt

unread,
Jun 10, 2021, 7:59:46 AM6/10/21
to nv-autocr...@googlegroups.com
Only the rows you want to send.  If you delete the status for all rows, all rows will be sent.
Reply all
Reply to author
Forward
0 new messages