Author Topic: How to send out another confirmation reminder  (Read 1948 times)

judy

  • Posts: 14
    • View Profile
How to send out another confirmation reminder
« on: April 03, 2008, 09:13:18 am »
I recently discovered that I had a problem with Bellsouth and emails were being bounced. I've since fixed that problem which takes care of my "Active" mailing list.

I'd like to send out another confirmation reminder to Bellsouth "Unconfirmed" addresses because I'm sure the confirmation email and confirmation reminders bounced.

How can I send out a confirmation reminder for just certain ISPs if the auto confirmation reminder limit has already been reached?
Thanks!

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
How to send out another confirmation reminder
« Reply #1 on: April 03, 2008, 12:27:54 pm »
The reminders are sent based on the "dateadd" field in the "lm_users" table.  Set that using PhpMyAdmin to a few days ago and the users should receive a few reminders (depending on your settings).

The following query will update all unconfirmed users on bellsouth.net to April 1st of this year.  Note that changing this may skew your "opt-in" evidence.
Code: [Select]
update lm_users set dateadd = '2008-04-01' where cnf = '0' and email like '%@bellsouth.net%';

Alternately you could create a User Selection to group unconfirmed addresses from that ISP, then craft your own "custom" confirmation email.  A "Confirm Link" message code should do the trick.  You may want to try it with a test address on a test list to make sure it works as expected.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting