The only way I've found to do it so far is to pick out the ppl I want to
send to and hten save them to a new workbook, then launch word, and do an
e-mail merge from there.

I'd rather have some way of e-mailing ppl directly from excel.  However,
when I try to record a macro sending and e-mail no code is recorded.

Can anyone tell me how I might go about doing this?

Thanks in advance

Rob

Try the download at http://ukww.net/patools which allows you to mail merge
entirely within Excel.

HTH
Paul