Using PHP to clean up my client list.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jeddiki
    Contributor
    • Jan 2009
    • 290

    Using PHP to clean up my client list.

    Hi,

    I have a client list which I have not sent out any
    email to for about a year, and I sent an email last week.

    Now my emails have an opt-out link which keeps the mysql
    database clean.

    But, how do I clean out the the non-deliverables?

    From my mail out ( of c.5000 emails), I got about 450 bounces.
    Obviously I don't want to keep sending out to emails to
    non-existent addresses so I want to somehow access those addresses and
    take them off of the clients table.

    The reason that I know that I get the bounces is because I get
    an email back to my sending email address saying that it was not
    deliverable.

    I have complete access to my server and I have been looking
    for the right files to use but I can not find them.

    My server runs the Postfix mail server and I use WebMin to admin it.

    Any ideas where I can find this information and how I can get it into a
    table ?

    Thanks
  • TheServant
    Recognized Expert Top Contributor
    • Feb 2008
    • 1168

    #2
    All I can think of off the top of my head (mainly because I don't know how to capture email addresses from a bounce) is to either get the active users to click an "I'm still active link" which will update a time (and then you can delete those with the time longer than a year or something) or to manually do it.

    However, there has to be a way to run something in the mail server to make a list of bounce's email addresses, and then remove the record from the database... Just not sure how.

    Comment

    Working...