View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gareth[_3_] Gareth[_3_] is offline
external usenet poster
 
Posts: 109
Default send file by e-mail

I am new to sending files automatically and am having trouble setting the
message body text.

I want three lines of text (with a blank line between them) and then the
attachment.

I have been trying to use the following:

Dim strbody As String
strbody = "Line 1" & vbNewLine & vbNewLine & _
"Line 2" & vbNewLine & vbNewLine & _
"Line 3

And then putting .Body = strbody

The text all appears OK but the attachment (which has a long file name)
'joins' itself to the end of line 3 text. Is there any way around this?

Gareth