Pyball wrote:
What I need to figure out is how to have the user enter an email
address into an input box then have the New email message ready to go
with the To: line filled in, and the subject line fill in with a
default subject, and the saved .txt file as an attachment.


All the options for sending email from Excel are well described at

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

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup