Email message body in VBA

[Anne Troy]

Can't seem to get it right.

.Body = "Here is some text" & vbLf
"and here is some more text" & vbLf
"and here I want a cell reference from a specific worksheet" HELP! & vbLf
"and then some more text."

Office 2000.

_________________
Anne@TheOfficeExperts.com
TheOfficeExperts
This message was edited by Dreamboat on 2002-10-28 01:14

 

[Joe Was]

[A1].Value

or

Worksheets("Sheet1").Range("A1").Value

Both these add the cell contents of cell A1 to your message. Hope this helps. JSW

_________________<INPUT type="JSW" value=" Excel On... Coder's!" ID=Text1><spanstyle='font-size:36.0pt;color:#FFCC00'>JSW<o></o></span>[/b]</p><spanstyle='font-size:36.0pt;color:#FFCC00'>Try and try again, " The way of the coder!"<o></o></span>[/b]
This message was edited by Joe Was on 2002-10-28 01:24

 

[Tom Urtis]

Just tested:

.Body = "Here is some text" & vbLf & _
"and here is some more text" & vbLf & _
Sheets("Sheet1").Range("A1").Value & vbLf & _
"and then some more text."

 

[Anne Troy]

Doesn't work, Joe.

Tom, yours doesn't even refer to worksheet range. I'm still working on it.

 

[Tom Urtis]

What kind of range are you referring to? I placed a value in cell A1 of Sheet 1 on a workbook from which I tested this line and it came out just fine on the Outlook email.


You must be referring to some other type of range; if so, what?

 

[Anne Troy]

Ah. I see. YOu changed it! Trying NOW.

 

[Joe Was]

Every step of your concatenation must have a "&" joining it to the next step!

 

[Anne Troy]

Yeah. I had it screwed up. It works fantastic!

Thanks so much guys!

It's T - about 4 hours. Really getting down to the wire on that one!!

REALLY appreciate the help!