SitePoint Sponsor |
|
User Tag List
Results 1 to 7 of 7
-
May 21, 2003, 10:42 #1
- Join Date
- Oct 2000
- Location
- Nashvegas Baby!
- Posts
- 7,845
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Access - Pruning one list of emails from another list of emails
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!Adobe Certified Coldfusion MX 7 Developer
Adobe Certified Advanced Coldfusion MX Developer
My Blog (new) | My Family | My Freelance | My Recipes
-
May 21, 2003, 10:46 #2
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
delete from maintable
where exists
(select 1 from bouncetable
where email = maintable.email )
-
May 21, 2003, 10:48 #3
- Join Date
- Oct 2000
- Location
- Nashvegas Baby!
- Posts
- 7,845
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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?
Adobe Certified Coldfusion MX 7 Developer
Adobe Certified Advanced Coldfusion MX Developer
My Blog (new) | My Family | My Freelance | My Recipes
-
May 21, 2003, 11:16 #4
- Join Date
- Oct 2000
- Location
- Nashvegas Baby!
- Posts
- 7,845
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Rudy...
Would this query be run from within Access or do I need to use CF?Adobe Certified Coldfusion MX 7 Developer
Adobe Certified Advanced Coldfusion MX Developer
My Blog (new) | My Family | My Freelance | My Recipes
-
May 21, 2003, 11:26 #5
- Join Date
- Oct 2000
- Location
- Nashvegas Baby!
- Posts
- 7,845
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Never mind. I got it working. That's beautiful Rudy. Thanks again.
Adobe Certified Coldfusion MX 7 Developer
Adobe Certified Advanced Coldfusion MX Developer
My Blog (new) | My Family | My Freelance | My Recipes
-
May 21, 2003, 11:42 #6
- Join Date
- May 2001
- Location
- :noitacoL
- Posts
- 1,859
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
You've been pretty quiet recently creole. Not that I blame you
-
May 21, 2003, 13:46 #7
- Join Date
- Oct 2000
- Location
- Nashvegas Baby!
- Posts
- 7,845
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yeah...I know what you mean. Impending marriage really takes the life out of posting on Sitepoint.
Adobe Certified Coldfusion MX 7 Developer
Adobe Certified Advanced Coldfusion MX Developer
My Blog (new) | My Family | My Freelance | My Recipes
Bookmarks