Exporting Targets from Target List

[Jirka]

I already posted in Power Prospecting, but i guess it is better to ask here.

My campaign has 180 bounced emails. I need to take these 180 contacts and send them to someone so they go through them and correct them.

Now, how do i export them? I managed to put them into a Target List, but it seems like a dead end. I dont see any way to export it.

Any hints ?

Thanks a lot,
Jirka

[Jirka]

Well we solved by the following SQL and export to Excel, not the cleanest of solutions, though

SELECT contacts.email1, contacts.first_name, contacts.last_name
FROM `prospect_lists_prospects` , contacts
WHERE prospect_lists_prospects.related_id = contacts.id
AND prospect_list_id = 'ccfdbe5a-d946-11eb-f127-47025ed7c322'