new line in VB


Posted by jevee on February 27, 2001 9:50 AM

Im using this command to transfeer data from 2 cells into outlook task. This works ok. But i want to have the information on seperate lines Data from cell5 on one line and data from cell9 on a line downunder. What is the command i have to use? and how does i place this??
Here is the command im using:

.Body = " Information from cell 5: " + Cells(r, 5).Value + " Information from cell 9 " + Cells(r, 9).Value

Please help me!!

Regards
jevee



Posted by GREGC on February 27, 2001 10:48 AM

response:

"info from cell5: " & vbnewline & "info from cell9"