body of mail and sheet.
 

hi

i have constructed a macro which copies cells from an input sheet to a
summary sheet which is then emailed as the body of a message to a specific
person.
However....
i would like to include a short block of text above the table, and am having
problems with putting it on new lines.
i have used "text" & Chr(13) &"text" - - this didnt work
i have used "text" & vbnewline & " text - - this didnt work.

any suggestions?
thanks
mike

body of mail and sheet.
 

Hi Mike

Try Chr(10)

Sub testmess()
MsgBox ("this is one line" & Chr(10) & "this is another line")
End Sub

worked fine for me
Regards

Roger Govier


mike wrote:
hi

i have constructed a macro which copies cells from an input sheet to a
summary sheet which is then emailed as the body of a message to a specific
person.
However....
i would like to include a short block of text above the table, and am having
problems with putting it on new lines.
i have used "text" & Chr(13) &"text" - - this didnt work
i have used "text" & vbnewline & " text - - this didnt work.

any suggestions?
thanks
mike

body of mail and sheet.
 

No luck.
Any ideas?

Mike

"Roger Govier" wrote:

Hi Mike

Try Chr(10)

Sub testmess()
MsgBox ("this is one line" & Chr(10) & "this is another line")
End Sub

worked fine for me
Regards

Roger Govier


mike wrote:
hi

i have constructed a macro which copies cells from an input sheet to a
summary sheet which is then emailed as the body of a message to a specific
person.
However....
i would like to include a short block of text above the table, and am having
problems with putting it on new lines.
i have used "text" & Chr(13) &"text" - - this didnt work
i have used "text" & vbnewline & " text - - this didnt work.

any suggestions?
thanks
mike