I use this automated email code from one of the experts however, I'd
like to change point the subject field to a cell reference - the value
(always a date) in cell G1.



..Subject = ""

Try this...

..Subject = Range("G1").Text

--
Rick (MVP - Excel)


"J.W. Aldridge" wrote in message
...

I use this automated email code from one of the experts however, I'd
like to change point the subject field to a cell reference - the value
(always a date) in cell G1.



.Subject = ""

Hi

..Subject = Range("G1").Text

Or

..Subject = Sheets("Sheet1").Range("G1").Text

The sheet reference is only needed if sheet1 isn't the active sheet.

---
Per

"J.W. Aldridge" skrev i meddelelsen
...

I use this automated email code from one of the experts however, I'd
like to change point the subject field to a cell reference - the value
(always a date) in cell G1.



.Subject = ""