You'll find plenty of examples of [URL="http://www.rondebruin.nl/sendmail.htm"]how to send email from Excel with VBA[/URL] over on [URL="http://www.rondebruin.nl/tips.htm"]Microsoft Excel MVP Ron de Bruin's site[/URL].
Obviously this is a fairly technical task, and there's much to discuss. I've successfully created a few email automation tasks by learning from the content found on Ron's site.
I don't recall having seen this topic discussed here within the Monarch forum previously. If after having read some of Ron's content you run into difficulties accomplishing your project, you may want to post a message requesting assistance within the [URL="http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/thread/b25b298696fedd64?q=exceloutlookmessagevbabruin#71aeba6de11f17f6"]Internet newsgroup for Excel programming[/URL]. As you can see from this link, Ron frequently contributes to the discussion.
Good luck with your project,