Excel VBA Macro to send emails & attachments

[Jordan2]

Hi,
I need some help in putting together a macro which matches the excel files in a folder to the name in the main folder and send only those ones out.

For example I have 10 excel files in my folder, let's say on the desktop:
Each folder is named 'Person 1' through to 'Person 10' and in the file it's got everyone's contact information.
How would I create this and produce only 10 emails with their 10 individual attachments?

Thanks.

 

[Jordan2]

You've got no PC at home, no USB stick to transfer my little file? I'm using skype for my individual file transfer ...

Not currently no, I am sure it would just be a few tweaks to my current code I found might get it to work?

 

[Jordan2]

Solved.

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.