Send object force new line after date

[Costefran]

Hi

Another question

I am using sendobject method to send an email with text taken from my current form (in a comments box)

Comments are entered over a varied time period with each comment being preceeded with a date stamp

Is there anymay to force a new line in the text using Chr(13) on the start of each date stamp so the email text looks something like

01/01/2008 Comment 1
02/02/2008 Comment 2
03/03/2008 Comment 3

Thanks

 

[JoeAtWork]

Looks like you would have to parse through the Comment field to figure out where dates are (maybe by looking for pattern ##/##/####) to insert vbCrLf (instead of Chr(13)).

Of course, the ultimate best choice would be to normalize the table so there are multiple comment records related to a parent table. Then you would not be required to do this kind of guessing where to split up the records.