Stripping Email Address From Linked Table

[ebizleads]

I have a linked fixed width table containing undeliverable messages from my email campaign. I need to strip out any occurance of an email address and append them to a table.

Thanks Guys!

Ebizleads

 

[Golom]

That's a bit fuzzy but assuming
[li]The email's are in a table called "tblUndeliver" and a field named "email" and[/li]
[li]You want to append them to a table called tblSavedEmail[/li]

INSERT INTO tblSavedEmail(email)
Select email From tblUndeliver

You'll need to add appropriate constraints in a Where clause if such there be.