ListMailPRO Email Marketing Software Forums
ListMailPRO Email Software
& Marketing Forums
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
ListMailPRO Email Marketing Software Forums
»
ListMailPRO Email Marketing Software Forums
»
General Help & How-To
»
Changing all AOL "Bounced" Records to "Active
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: Changing all AOL "Bounced" Records to "Active (Read 1724 times)
DB
Posts: 12
Changing all AOL "Bounced" Records to "Active
«
on:
August 29, 2004, 10:01:46 am »
I have a list of over 4000 addresses with over 900 AOL addresses marked "Bounced" because of a problem with AOL that has now been resolved. I want to change these AOL addresses back to "Active". Is there an easy way to do this without having to edit each individual record?
Logged
DW
Administrator
Posts: 3787
Changing all AOL "Bounced" Records to "Active
«
Reply #1 on:
August 30, 2004, 06:08:21 am »
If you know how to run a custom command with PhpMyAdmin, try the following MySQL query:
(users marked as bounced have "cnf" set to "2", active users have a value of "1")
Code:
[Select]
update lm_users set cnf = '1' where email like '%@aol.com';
Logged
Dean Wiebe
ListMailPRO
Author & Developer -
Help
|
Support
|
Hosting
Print
Pages: [
1
]
Go Up
« previous
next »
ListMailPRO Email Marketing Software Forums
»
ListMailPRO Email Marketing Software Forums
»
General Help & How-To
»
Changing all AOL "Bounced" Records to "Active