# Bulk update bounced contacts to non-bounced **URL:** \ **Category:** Product Support\ **Created:** [February 16, 2024, 4:32am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909 "2024-02-16T04:32:27Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![gathh](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gathh/32/6515_2.png) [@gathh](https://forum.mautic.org/u/gathh)\ **Post date:** [February 16, 2024, 4:32am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/1 "2024-02-16T04:32:27Z")
**Your software** My Mautic version is: 4.4.10 **Your problem** My problem is: How can I bulk update 50,000 bounced contacts to non-bounced contacts? Sparkpost mistakenly tagged emails as bounced that are in fact not bounced (independently verified with [neverbounce.com](http://neverbounce.com)). No I want to remove the bounce tag from these contacts. Is there a way to do this in bulk? Thank you. ---
**Author:** ![gordon.hu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gordon.hu/32/5622_2.png) [@gordon.hu](https://forum.mautic.org/u/gordon.hu)\ **Post date:** [February 18, 2024, 2:53am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/2 "2024-02-18T02:53:54Z")
I think you should take two steps: 1. Set a separate segment for 50000 contacts 2. Set a campaign with Action “Remove Do Not Contact” I think this way it should be able to work for you. Good luck to you. ---
**Author:** ![gathh](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gathh/32/6515_2.png) [@gathh](https://forum.mautic.org/u/gathh)\ **Post date:** [February 18, 2024, 3:14am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/3 "2024-02-18T03:14:38Z")
> [@gordon.hu](#): > > Set a campaign with Action “Remove Do Not Contact” Thank you very much for your suggestion. How do you do this: Set a campaign with Action “Remove Do Not Contact”. ---
**Author:** ![gordon.hu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gordon.hu/32/5622_2.png) [@gordon.hu](https://forum.mautic.org/u/gordon.hu)\ **Post date:** [February 18, 2024, 3:40am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/4 "2024-02-18T03:40:46Z")
![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/4/43c4815ff038705b853b822fff21c9e32287f776.png) Set the action of the segment for 50000 contacts to “Remove Do Not Contact”, please refer to the screenshot. Hope to solve your problem. ---
**Author:** ![gathh](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gathh/32/6515_2.png) [@gathh](https://forum.mautic.org/u/gathh)\ **Post date:** [February 19, 2024, 2:19am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/5 "2024-02-19T02:19:12Z")
Thank you very much for this - much appreciated. ---
**Author:** ![riverbear](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/riverbear/32/9207_2.png) [@riverbear](https://forum.mautic.org/u/riverbear)\ **Post date:** [February 19, 2024, 1:44pm UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/6 "2024-02-19T13:44:50Z")
Will this have the effect of removing ‘Do Not Contact’ designation, ‘Bounced: EMAIL’ designation, or both? I am asking as I would like to execute this type campaign but only want to affect those with ‘Bounced: EMAIL’ and not ‘Do Not Contact’ ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [February 19, 2024, 1:49pm UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/7 "2024-02-19T13:49:59Z")
Alternatively you can delete bounced contacts like this: DELETE FROM lead\_donotcontact WHERE reason = 2; Values for query can be found here: [mautic/app/bundles/LeadBundle/Entity/DoNotContact.php at 8959f6dbdccda152170b642c018a7047cf51e32e · mautic/mautic · GitHub](https://github.com/mautic/mautic/blob/8959f6dbdccda152170b642c018a7047cf51e32e/app/bundles/LeadBundle/Entity/DoNotContact.php#L10) ---
**Author:** ![wifi9823](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/wifi9823/32/10797_2.png) [@wifi9823](https://forum.mautic.org/u/wifi9823)\ **Post date:** [October 1, 2024, 1:50am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/8 "2024-10-01T01:50:34Z")
> [@mzagmajster](#): > > DELETE FROM lead\_donotcontact WHERE reason = 2; Where and how do you execute `DELETE FROM lead_donotcontact WHERE reason = 2;` ? ---
**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\ **Post date:** [October 1, 2024, 6:03am UTC](https://forum.mautic.org/t/bulk-update-bounced-contacts-to-non-bounced/30909/9 "2024-10-01T06:03:31Z")
In your mautic database. You can access via terminal or web ui like PHP my admin