cell value

B

bob

How do I get a cell value - I want to use the text in P3 for the subject line in an email using .sendmail "address@address", cell P3 text her

THANKS
 
R

Ron de Bruin

Hi bob

For more examples visit my website

Use a cell containing an email-address like this
..SendMail Sheets("mysheet").Range("a1").Value, _
"This is the Subject line"

Use also a cell for the subject like this.
..SendMail Sheets("mysheet").Range("a1").Value, _
Sheets("mysheet").Range("b1").Value
 
Top