Output memo field from access

[Anna]

Hello:

I am outputting Access fields to Outlook using
msgItem.HTMLBody. It is one large string. The problem is that the memo
type field is loosing in the process CR (carrage returns) and outputs all
paragraphs together. It creates some problems of us. Is there any way to
output memo field retaining CRs so it shows the same as in the Access field.
Can you help?

 

[Sue Mosher [MVP-Outlook]]

Either set Body instead of HTMLBody, or use a fully tagged HTML content string to set HTMLBody.

 

[Anna]

Hello:

Thank you for your response. I tried msgitem.body and it outputs the "memo"
field as it was entered by the user with all the CReturns - which is what we
would like to have. However, I am loosing advanced formatting features
which html provides (tables, bold, fonts, centering, etc.)

 

[Sue Mosher [MVP-Outlook]]

If you want advanced formatting, you would need to provide fully tagged HTML to the HTMLBody property.

 

[Anna]

Hi Sue:

What I have right now working is html body format with HTML tags. The
problem is that I have concatenated fields from database and one of them is
of memo type. Memo field may contain CReturns and separate paragraphs. With
this type of output new line/CR that user entered into memo field (with
CTRL-Enter) would be outputted as one continuous line. So this has nothing
to do with tags but rather with the way the memo field is presented in
Outlook. I am afraid that the solution to this problem may not exists.
--
Anna

If you want advanced formatting, you would need to provide fully tagged HTML to the HTMLBody property.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Sue Mosher [MVP-Outlook]]

Yes, it does have everything to do with tags. HTML doesn't support CR characters. You will need to replace then with appropriate HTML, either <br> tags (easy) or full <p></p> (harder).

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

Hi Sue:

What I have right now working is html body format with HTML tags. The
problem is that I have concatenated fields from database and one of them is
of memo type. Memo field may contain CReturns and separate paragraphs. With
this type of output new line/CR that user entered into memo field (with
CTRL-Enter) would be outputted as one continuous line. So this has nothing
to do with tags but rather with the way the memo field is presented in
Outlook. I am afraid that the solution to this problem may not exists.