Hi guys,

I'm looking for some help as I didn't managed to achieve what I'm looking for on my own.

Capture.JPG

What I would like to do is the following: For each line/country once I run my macro a different email is sent to the potential email written in Column B to D with the subject of my mail being Col E. In the body of my email I would like to see the Col F but watch out the text need to be formatted nicely like

Dear France,

Please find attached your results for 2014 (basically I need to know how to add extra empty lines).

And finally attached the file which I linked in Col G.

I hope my request is clear. In advance thank for those who will help, this would be a very nice xmas gift for me.