View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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