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" <(E-Mail Removed)> wrote in message
news:a24630d4-7746-427b-8c74-(E-Mail Removed)...
>
> 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" <(E-Mail Removed)> skrev i meddelelsen
news:a24630d4-7746-427b-8c74-(E-Mail Removed)...
>
> 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 = ""
>
>