cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Don't want #value in cell 4
Conditional Formatting by date 6
Calculate Sum in one cell after Exiting (ENTER or TAB) another cel 2
copy down 9
Extend Formula, but not Color 2
Excel pivot tables - specific expand/collapse buttons visibility 1
Help: Modulo... not... quite...right... 3
another formular help please 2

Back
Top