Access - Pruning one list of emails from another list of emails

**creole** · May 21, 2003, 10:42

Hey guys.

My company sent out an email blast a few weeks ago. There were quite a few emails that bounced back. Now I need to remove those emails from the main list. Is there any easy way to do this straight from within Access? If not, I've got ColdFusion and can write a script that can do this. I just want to have done with this in as easy a manner as possible.

Any leads would be great!

**r937** · May 21, 2003, 10:46

delete from maintable
where exists
(select 1 from bouncetable
where email = maintable.email )

**creole** · May 21, 2003, 10:48

You've got to be kidding Rudy! There was less than 5 minutes between my post and yours! I'll test it out as soon as I've got all of the bounced emails compiled. Dare I say that you kick butt?

**creole** · May 21, 2003, 11:16

Rudy...

Would this query be run from within Access or do I need to use CF?

**creole** · May 21, 2003, 11:26

Never mind. I got it working. That's beautiful Rudy. Thanks again.

**hillsy** · May 21, 2003, 11:42

You've been pretty quiet recently creole. Not that I blame you

**creole** · May 21, 2003, 13:46

Yeah...I know what you mean. Impending marriage really takes the life out of posting on Sitepoint.

The SitePoint Forums have moved.

User Tag List

Thread: Access - Pruning one list of emails from another list of emails

Thread Tools

Display

Access - Pruning one list of emails from another list of emails

Bookmarks

Bookmarks

Posting Permissions