I have managed to add a macro in excel that automatically sends email
from excel using

http://www.rondebruin.nl/sendmail.htm

However, Can someone please tell me how I add new paragraphs in th
body of the email.

I want it to say in the body:


"Please find attached"

"Kind regards

"name"

I can't seem to edit .body correctly - anybody got any suggestions?

Thank

--
Message posted from http://www.ExcelForum.com

check out the following file- Be aware later versions of office (pos
2k) have problems sending the e-mails so i have introduced a manua
send.

'Excel Index' (http://uk.geocities.com/duncankarran/excel-index.html


And go to the training mailer.

Duncan
soon to be 'excel.duncan-fiona.co.uk
(http://www.excel.duncan-fiona.co.uk

--
Message posted from http://www.ExcelForum.com

Thanks but when I download the spreadsheet, I cannot look into the macr
as it permanently asks if the email has been sent and then opens anothe
email!??

Any other suggestions

--
Message posted from http://www.ExcelForum.com

Go back to Ron's site. He covers about all the options you could want.

--
Regards,
Tom Ogilvy

"twogoodtwo " wrote in message
...
Thanks but when I download the spreadsheet, I cannot look into the macro
as it permanently asks if the email has been sent and then opens another
email!??

Any other suggestions?


---
Message posted from http://www.ExcelForum.com/

Like Tom already told you look on the Tips on my site.
http://www.rondebruin.nl/mail/tips2.htm

vbNewLine makes a new line

Dim strbody As String
With ThisWorkbook.Sheets("Sheet1")
strbody = "Hi there" & vbNewLine & vbNewLine & _
.Range("A1") & vbNewLine & _
.Range("A2") & vbNewLine & _
.Range("A3") & vbNewLine & _
.Range("A4")
End With

Change the Body line to .Body = strbody to use the string.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Tom Ogilvy" wrote in message ...
Go back to Ron's site. He covers about all the options you could want.

--
Regards,
Tom Ogilvy

"twogoodtwo " wrote in message
...
Thanks but when I download the spreadsheet, I cannot look into the macro
as it permanently asks if the email has been sent and then opens another
email!??

Any other suggestions?


---
Message posted from http://www.ExcelForum.com/