Email from Excel with Selection of Cell Value
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
|