It's only ever brought up on screen occasionally (TSWLM, FYEO, TLD) but when it is, it's very powerful. In the novels it wipes him out and the majority of the next novel You Only Live Twice he's a downright mess.
You Only Live Twice happens AFTER his wive's death?
I didn't know that
YOLW might be my favourite Connery bond
And, uhh, what are those acronyms?