On each page there is a link to a tips page
You can use this

.Subject = "reminder " & ThisWorkbook.Sheets("Sheet1").Range("F3").Value & " " & ThisWorkbook.Sheets("Sheet1").Range("G3").Value




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"franciz" wrote in message ...
Hi all,

I am using the codes from Ron"s <http://www.rondebruin.nl/sendmail.htm.
However, I would like to include the value of the cell in the subject line.

For example, I would like to have the contents in row 3, col F and row 3,
col G
appear in the subject after "reminder"

How do I include this in the codes.
.Subject = "Reminder"
And is it possible to include the row's content into the body of the msg?

Thank in advance.

cheers, franciz