Mind over body? Who wins?

The body, hands down, every time.

Which just means that he's finally become like a relative, the curse of over-familiarity. The two of you have to start playing games where you pretend to be strangers ("What did you say your name was?"). Or else reprogram sexual arousal to where it is triggered by emotional attraction. I've known a few couples that somehow fell into the latter from the beginning (primarily from rural culture), but how one starts getting damp or erect from sheer personality and acts / feelings of affection is an internal rewiring task that each individual has to work-out for themselves. In terms of classic stereotyping, women should already be more innately amenable to it than men.

Perhaps you have misunderstood the relationship.

He is a "friendship" to you. He is not a sexual excitement to you.

(It is rare when they are in combination. But it does exist.)

Be honest with yourself: check yourself the 8 Fold Path Way: Do you have the right intention, vision, speech, action, mindfulness, etc. of the situation?

The answer will come to you when you look at yourself honestly.

They are meant to be balanced - the mind affects the body, and the body affects the mind. If you want to be attracted again, it's likely that both of you need to regain the balance.

One way to regain the balance is to go back to the gym (seriously). But of course if you become obsessed with it, then the balance is lost once again.

Hey man/woman, 'Its the mind u have in mind'.' A useless body as u say'.
But woman, u need to understand ones feeling if u have. use your brain and think from the heart when it comes to love. Then only u will get the pleasure of love.
Instead of thinking love from your brain or through some one else brain. Use your own heart and brain.
And remember its important to make yourself fit and beautiful always, coz thats how u will enjoy love more.

This is a completely incomprehensible post, and has absolutely no relation to what i posted.

Let me put it another way--an equally crazy-sounding way, I know: As I understand Buddhism, there is no ego or soul to inhabit the "vessel" as you call it. I AM my body, but my body is an expression of the entire physical Cosmos. When I die, this intrinsically impermanent body disintegrates, an expression of the on-going and continuous Cosmoic flux, of the incessant modification of the Totality's configuration. In dying I return to the total ground of my being--like a drop of water to the Ocean-- I remain, as I was before and while alive, intrinsically one with it.
Take that Set.

...interesting enough that last post of yours...nevertheless I want to ad that the "soul" of your body the so called anima of it, ultimately it is the actual fact that such algorithm can truly operate even when you are gone, or long before you were actually born...that is to say, that such combination of functions can truly exist and work, that such string of information is potentially meaningful for the cosmos and thus never lost...eventually, it will end up in the event horizon of a black hole and nevertheless conserved.

No matter, never mind.