65.9K
CodeProject is changing. Read more.
Home

Exclamation character getting inserted in body of mail messages sent programmatically using CDO object.

starIcon
emptyStarIcon
starIcon
emptyStarIconemptyStarIconemptyStarIcon

1.67/5 (11 votes)

Apr 4, 2006

CPOL
viewsIcon

29730

Exclamation character getting inserted in body of mail messages sent programmatically using CDO object.

Introduction

Exclamation character getting inserted in body of mail messages sent programmatically using CDO object.

char1.jpg



Cause:
This is happening because RFC 2822 places limits on the number of characters in a line. According to section 2.1.1 of RFC 2822 (document attached), lines in a message MUST be a maximum of 998 characters excluding the CRLF. If the number of characters in a line exceeds the limit, exclamation mark followed by CRLF character gets inserted automatically in the message body.

Solution: While forming body text, if we append line feed character after every nth (n < 998) character or so, then this problem will get resolved. ‘Char(10)’ can be used in SQL 2000 stored procedures as a line feed character.