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
|