Cell reference in code

[J.W. Aldridge]

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 = ""

 

[Rick Rothstein]

Try this...

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

 

[Per Jessen]

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.