How to re-send an edited followup to people on current delay

[lynda.kane]

Hi All,

I stopped a follow-up going out (after 500 of 3000 had goneout) as it needed some link corrections - hadn't finished the edit and forgot followups are automatic not like a 'send email'!

I edited it and re-saved it and naively (stupidly!  thought it would then re-send like a 'send email'. Of course it didn't, so I edited it again and 'reset all users to current delay' of 0. but it still hasn't been requeued/resent.

How can I resend an edited follow up - delete it and re-add it?  I hope not!

Tks,

Lynda

[DW]

Lynda,

As each followup is queued to ListMail the users position in sequence is incremented.

If the message seq # is 2, all of those users will now be set to receive message #3 next dailymail (or after message 3's delay value is satisfied).

Therefore, you could run a custom MySQL query to update all users on message 3 back to 2 for that list.

Assuming list is "1", the query would be:

Code: [Select]

UPDATE lm_users SET cseq = '2', cdel = '0' WHERE list = '1' AND cseq = '3';
This query can be run within PhpMyAdmin, commonly available from within your web hosting control panel.  Load phpMyAdmin, click the database, click "SQL" at the top of the page, then paste the query, modifying it to match your list and sequence numbers.

Regards

[lynda.kane]

Thanks Dean,  

So even those who didn't get it (because I stopped the send) still get incremented up the sequence?

Lynda

[DW]

Lynda, yes, as the message is queued into the ListMail system the user is moved up in sequence.  Once it starts "sending to the server" the ListMail queuing process has already completed.

Regards

[lynda.kane]

Thanks for the clarification. Did what you suggested (with a bit of help from my ISP) and it worked a treat!  Thanks

Lynda