Savva, Annabelle
2008-01-31T16:09:00Z
Hi,

Hope someone might be able to help...

We are trying to concatenate 2 fields from a database into Outlook calendar body field with a line break between the two fields, E.g.

Title:This is a test
Notes:Sample calendar activity

The fields inserts into body of a calendar entry lovely, however without the line break. E.g.
Title:This is a test Notes:Sample calendar activity

We have included the following in SQL
1.
'Title:' + ACT_Title +
+ '
' + ' Notes:' + ACT_Notes as ActBody

2.
'Title:' + ACT_Title + '=0D=0ANotes:' + ACT_Notes as ActBody

3.
'Title:' + ACT_Title + '<BR>Notes:' + ACT_Notes as ActBody

But none of the above work...Does anyone know of how to insert a line break? Can it be done???

The reason we want it to work like this is because we are already populating the Subject field in Outlook with another concatenated string from the database
Administrator
2008-01-31T16:16:00Z
Hello,

Outlook uses the following new line characters:

Line Feed
Values:Oct=12, Dec=10, Hex=a

Carriage Return
Values:Oct=15, Dec=13, Hex=d
Administrator
2008-01-31T16:18:00Z
You can also store body text from Outlook to a DB table column (dummy item with new lines etc..)and investigate the Value.
Savva, Annabelle
2008-01-31T17:25:00Z
Thank you Admin

Tried your first option and it worked. Changed the Notes concatenated string to:


'{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{\*\generator Riched20 5.40.11.2210;}\viewkind4\uc1\pard\f0\fs20 Title:'+ACT_Title + '\par
Notes:'+ CAST(ACT_Notes AS varchar(8000)) + '\par
}' as ActNotes