So I found out last night that DP has had quite a lengthy emotional affair with a colleague. They started as friends and she relied on him for emotional support for quite a time. Up until recently this involved lunch every so often and chats by text. In the past few months this evolved to some pretty lame sexting and some pictures of her boobs. He says he thought he loved her but now realises he doesn't. The affair was not physical (I know this for an absolute fact).
It's complicated because DP is a charismatic man but he has some physical problems which in turn has led to a lot of emotional issues. We have not been getting along for a while now (surprise) but he's been horrendous since the sexting began (last few weeks). The woman has apologised profusely to me and her story matches perfectly what DP is saying. She liked the attention and has no intention of breaking up her family.
I am in bits. Any advice would be gratefully received.