ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: susan1 on March 22, 2007, 01:00:55 pm

Title: re-opt in to a subscriber list
Post by: susan1 on March 22, 2007, 01:00:55 pm

What is the best way to take a list of active subscribers and have then reopt in to the list?  Is there a way to set them as unconfirmed so I can have them reopt in?  

Thanks for your help!

Title: re-opt in to a subscriber list
Post by: DW on March 23, 2007, 12:53:20 am

Currently this is only possible with a custom query through a tool like PhpMyAdmin (example for list 1).

Code: [Select]

update lm_users set cnf = '0' where list = '1' and cnf = '1';
After that you would set up a User Selection to send to all Unconfirmed users, and manually send a confirmation email that includes a "Confirm Link" message code, ie !confirm.

Regards