Emailing from Excel.

Does anyone know some code for automatically emailing files to
people that are contained within a spreadsheet. ie the code should recurse
through the names pick up the first one send them the relevant file then
back to excel pick up the next nameand send it to the person. Any help
would be extremely helpful.