hi Mike,

I'm pleased I could help - thanks for the feedback

So you'd like a book to read - cool, the VBA bug may be catching
I'm still learning too & not an expert (here's some of them - http://www.mvps.org/links.html#Excel). I find that reading through threads on this & other Forums is very useful & have read a few books. John Walkenbach's Power Programming titles are a reasonably easy read (& may open your mind to other possibilities) & I'd also recommend hunting for & downloading "Spreadsheet Modelling Best Practice" by Nick Read and Jonathan Batson for general design suggestions.

Stan has made some suggestions here:
http://www.excelforum.com/excel-gene...-in-excel.html

The below link has some more reading, but as my signature says I think the best way to learn is to experience, so play with the macro recorder & then review/breakdown the recorded code to increase your knowledge.

http://www.excelforum.com/excel-misc...additions.html

Recording macros of your actions will give you the basis of your actions for your next projects & Ron's below pages should help with your email task.
http://www.rondebruin.nl/sendmail.htm
http://msdn.microsoft.com/en-us/library/bb268022.aspx
(this may be a copy of the first one - I just found it & haven't read it.)

If you're happy with the solution, can you please mark the thread as solved (instructions are in the Forum Rules)?
Feel free to add to my reputation by clicking on the blue scales at the top right of one of my posts - it is appreciated.

hth
Rob