Struggling to cope with aspects of my relationship

[TunnocksTastyTeacakes]

I'm engaged, we've been together 7 years, lived together for a year now. I've been taking antidepressants for 3 years and they affect my libido. I love my fiance and want to spend the rest of my life with him. I find him very attractive, I just have no libido. However, because I want him to be happy we have sex every night. We have spoken in the past about my libido, but couldn't find a solution, as we wanted to stay together, but he wants sex. I now pretend I want it too, because it's easier that way. However, I just can't get into it and I now dread bed time, look for excuses without it being obvious.

I don't know what advice I'm looking for really. Telling him is not an option, because we've talked it through before and the only other solution was splitting up, which neither of us want. Is anyone else in a similar situation and how do you cope?

Please don't judge me, I'm not asking for opinions on whether this is right, just maybe some ways to make it easier. I can't stop the antidepressants, I don't think I'd be here without them.

@TunnocksTastyTeacakes

I'm not having sex to stop him having sex elsewhere though, I want him to be happy and I want to be with him. He hasn't threatened to leave if we don't have sex. I just can't see another solution other than splitting up.

I would love a solution, I'm not sure there is one. I think I was hoping someone had been in a similar situation and found a way of coping .. I'm not sure. We love each other and want to be together. I think he'd be upset if I told him I have sex just for him.

No children planned, I'm in my early forties and have not really had the urge yet to have children.

I cannot believe you are allowing yourself to be in this situation in your early forties. I honestly thought you must be in your early twenties to be a) asking for our advice on this b) putting up with it in the first place.

I think you're going to have to be honest with him and tell him you don't want sex every day.

You don't have to hurt his feelings. Just tell him you're tired or sore. It is likely distorted thinking, part of depression thinking you have to do it daily.
Try it and just say how about we skip tonight. You never know he might be relieved.

Another option is for him to take anti depressants to lower his drive.

I can't imagine being the sort of person that expects sex from a partner regardless. How is that attractive?