Reporting for hand holding duty.
I am so sorry that this is happening to you.
I have walked in your shoes and can only say that things will get better. Admittedly they will probably get worse first but they will get better and you will go onto find happiness again.
If your husband is remorseful, ready to be honest and willing to help you heal and rebuild your trust then you may be able to find that happiness again with him.
If he is not ready to do all that you will somehow find a way to move forward and find happiness again without him.
Also remember you do not need to make any decisions or choices now.
My best advice to you would be to try to get some ducks in a row - just in case you decide that this is the end of your marriage. I would also do all this before confronting him.
If you have proof of his affair (screen shots /emails) make electronic copies and send them to a secure new email account.
Put all important documents in a safe place (I locked mine in my desk at work). Examples are birth certificates, passports, copies of salary slips, bank statements, tax returns etc. Take a copy of all current bank balances.
I also opened another bank account and moved 50% of all funds there. So many guys drain bank accounts and leave women in a dangerous financial situation.
Find out who the hottest sharkiest divorce lawyers are in town. Make appointments with the top 3 and see them for advice. This prevents your husband using any of them in the future - and limits his choices.
By taking these steps it does not mean you will divorce but takes back some control for you. It also means that if you do decide to divorce you are in a strong starting position.
If you decide you want to reconcile he really needs to show remorse and empathy for the pain he has caused you. Regret he has been caught is not enough. He will need to show you through his actions that he is willing to put in the hard work.
Also however much you want him don't make this easy for him. Don't let him have his cake and eat it too.
If he thinks he can remain living with you and carry on the affair show him this will not happen. Stop cooking for him. Stop doing his washing. Let him see how his life will be without you.
A lot of the thrill of an affair is the secrecy. Shine a light in it and it soon loses its appeal. If the ow has a partner - please find a way to inform him.
This happened to me. I ended our marriage. It was rough and tough but I now have a loving happy relationship with the kindest most respectful guy you could wish to meet.
My exes affair turned out to be an incredible life changing event.
I hope that you too can find your way back to happiness.