Hi Scott,

Ron de Bruin has an extensive set of exanple
procedures for sending emails at:

http://www.rondebruin.nl/sendmail.htm

See for example:

Sub Mail_Sheets_Array()
http://www.rondebruin.nl/mail/folder2/mail3.htm

You could easily replace the hardcoded values for To,
Body, Subject etc with cell referencea or an array of
values


---
Regards,
Norman


"Scott Townsend" wrote in message
...
I have several Worksheets that I want to create emails from.

I want to populate the To: Subject: and body from cells in the
spreadsheet.

Whats the best way to do this?

Thank you,
Scott<-