Outlook Task Item Body

[sgolder]

How do you add multiple lines of information to a Outlook Task Body in VBA?

 

[Von Pookie]

Are you wanting to do this from Excel, or use VBA in Outlook?

 

[sgolder]

From VBA in outlook

 

[Mr. Wizard]

Outlook Task Body

If you want to add multiple lines to a message body in VBA, you will need to join strings together to form one long string for the message with carriage return characters in ASCII format.

The code will look something like this:

.body = "First line of text." & chr(13) & "Second line of text."


'Each of the chr(13) feeds the ASCII code for a carriage return into the line, and the ampersand (&) joins the string elements into a single string of text.

.body = Cells(1,1) & chr(13) &chr(13) & Cells(2,1)

'This code takes the contents of spreadsheet cell A1 and puts it into the message, and then drops down 2 lines so there is a blank line in between the paragraphs, and then adds the contents of spreadsheet cell A2.