How to send email with attachment

[staciam]

I am relatively new to Excel. I am the assistant to the hiring manager and have been asked to make her job easier. I have already created an Excel spreadsheet with names of applicants as well as their email and dates they were interviewed. We need to send an email with 7 attachments to new hires. Right now we are copying and pasting from the spreadsheet into Outlook and attaching all docs by hand. I would like to have a "Send" link that will pull the applicants email from the appropriate cell, attach all 7 docs, fill in the subject and body of the message, and then open the Outlook pop up so I can click "Send" and have the email go out. I've searched the internet and found all kinds of script but I don't know where to put the script or how to customize it! I finally figured out how to access VBA but I don't know what to do from there. I really need kindergarten steps at this point. Any help will be greatly appreciated!!

[DonkeyOte]

A good starter:

http://www.rondebruin.nl/mail/folder2/files.htm

Obviously in your case you want to send the same files to each person so you can adjust that element to your needs.

Note the comment re: .Display rather than .Send

Incidentally I've moved this from Outlook to Excel Programming

[staciam]

I've seen a lot of sites with similar information... I can get as far as VBA and setting the Outlook Library, but then what? Where does the script go? And the notes where they tell people to edit as needed, I don't know what to edit! I found another site where the writer said "make sure you have already set macros to..." and I don't know what that means or how to do it. I need baby steps, like click here, then type here, then click here. I've done some web design and know html so I am not completely computer illiterate but Excel is a whole new ballgame for me.