I'm trying to find a way to have a macro sending emails to a group of people with attachments.
What I would love to have exactly is that I input the country in Column A and then the macro runs and create one email per country with the subject from Col B, and the body from Col C. Ideally it adds automatically my signature at the end which is set up in Outlook (2010).
Then the email needs to be sent to the people in Col E to G with respect of To, Cc and Bcc. Finally it looks at the 3 attachments (potentially) linked on my computer in Col H to J.
It's also important that the macro don't override the space/extra line in the body section and respect how I wrote it. Potentially the list of Country can be up to 20. Last but not least it would be great if it could prepare the email but not send it like this it allows me to have checks and make modifications.
It would be amazing if one of you could help me as I spent quite some time already and I'm still far from the results I'm looking for. Please let me know if you have any questions.