Howdy,
I'm looking for help removing bounced and unsubscribed e-mails.
I have a CSV file with all the bad e-mails. I need a compare and remove statement that will delete the e-mail address only from the Customer Table.
Or any other workaround to keep me from doing 400+ manually
thanks
I would use MS Access to connect to both data sources, join the csv to the customer table on the email field, and then update the emailaddress to a blank string. The sql code would look something like this:
UPDATE temp INNER JOIN dbo_Customer ON temp.email dbo_Customer.EmailAddress SET dbo_Customer.EmailAddress = "";
"c> Howdy,
Have something to add? Share your thoughts — no account required.
Ask the community — no account required