Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
send file by e-mail
try
strbody = "Line 1" & vbNewLine & vbNewLine & _ "Line 2" & vbNewLine & vbNewLine & _ "Line 3 & vbNewLine & vbNewLine -- Regards, Tom Ogilvy Gareth wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Sending file using File/Send to/Mail Recipient | Excel Discussion (Misc queries) | |||
Excel - Sending file using File/Send to/Mail Recipient | Excel Discussion (Misc queries) | |||
How do I only send 1 worksheet of a file in an e-mail? | Excel Worksheet Functions | |||
Send e-mail from a Excel file | Excel Worksheet Functions | |||
File-Send To-Mail Recipient (for Review) | Excel Discussion (Misc queries) |