I've had a good look around Ron de Bruin site conerning e-mailing and is it
correct to say that you can't put pre-defined text in the message body of an
e-mail via excel? The links off Ron's page indicate that you can do it
through Outlook, but I need it via Express

Secondly, can I reference a cell value on a worksheet within the Subject
line of an e-mail. Not sure of the exact syntax I should have, say the value
that is returned in Sheet1 C7 (this is from a Data Validation drop down
list) I'm looking to insert on the Subject line of the e-mail.


Thanks