How do you write a good thoughtful condolences email?
The best thing that you can do is write from your heart. As this is a very hard time for your friend, I am sure that he/she will appreciate any kind words coming from friends and family. Keep it short and simple and end the email with an open invitation to go out for drinks or a bite to eat (or some simple activity that you know they will enjoy) when they feel up to it.