| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| e mail same body different subject | Excel Discussion (Misc queries) | |||
| Mail as body | Excel Discussion (Misc queries) | |||
| Body for e-mail using sendMail | Excel Programming | |||
| Formating Body When Sending Mail | Excel Programming | |||
| Mail Sheet as message body | Excel Programming | |||
Linear Mode
