Output Memo field to Outlook body

A

Anna

Hello:

I am outputting fields to Outlook body message. What I have right now
working is html format with HTML tags (one large string with tags and
formatting). 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 lines/CR and paragraphs that user entered into memo
field (with CTRL-Enter) would be outputted as one continuous line and are
lost. This creates problems. I cannot control memo field with Html tags, I
believe. It is just taking the field and outputs text to Outlook as one long
string. Is there any method that it would look the same as entered in Access?
 
R

Ron Hinds

Anna said:
Hello:

I am outputting fields to Outlook body message. What I have right now
working is html format with HTML tags (one large string with tags and
formatting). 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 lines/CR and paragraphs that user entered into
memo
field (with CTRL-Enter) would be outputted as one continuous line and are
lost. This creates problems. I cannot control memo field with Html tags,
I
believe. It is just taking the field and outputs text to Outlook as one
long
string. Is there any method that it would look the same as entered in
Access?

Replace([Memo_Field], vbCrLf, "<BR>")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top