Excel to Outlook Small Question

[twogoodtwo]

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

 

[DNF Karran]

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

 

[twogoodtwo]

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

 

[Tom Ogilvy]

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

 

[Ron de Bruin]

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

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