Macro to send different emails to different people with attachment

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.

Can you add your file attachment to this - I can help with this for you.
Also, can you confirm whether it is Outlook or Lotus Notes you want to send the email via?

Please find attached the excel file.
I confirm that I'm working with outlook and yes I would need as many email as line/country I could fill.
Thanks.

Macro forum.xlsm

Hi Naveed Raza,

Wow this is pretty impressive in such a short time. I just reviewed it with my boss and unfortunately he wants to modify a little bit the file as per new attachment.
The logic is pretty much the same but it would give us more flexibility if I need to edit the code as yours is too complex for me.

There is one more thing that need to be added if possible. At the end of the file you can see from Col J to Macro forum v2.xlsmP the people that need to be in "to" in the mail and from Q to U in "cc". Because I'd like to have only one email sent per country to all the people in the same time vs one separate email per person in your macro.

2 things that I really liked in your is the button to launch the macro and especially the fact that the mail is ready to be send but not yet sent (it give me the chance to review it if needed).

Do you think it would be feasible for you to include all those changes or am I too much a pain in the a**.

Macro forum v2.xlsm

Yes sure take your time, I'm not working until next Monday anyway.

Hi Naveed,

any chance I can still count on your help for this one?
Thanks in advance.