'Sendmessage' to Outlook puts extra space before carriage return

Does anyone know how I can get an Access/Outlook translation to not put
a space character before each carriage return in a memo field? I am
populating my database's memo field "Notes" with the text I want to go
into my email. I then use the sendmessage command in VB to take this
text and put it into a new Outlook email. The problem is that once the
text goes into the email message, a space character has been inserted
at the end of each line which has a hard return in the memo field.
This space is definitely not there in the original memo field's text.
This dangling space character causes my Outlook grammar check to show a
little green line at the end of each paragraph which means "extra
space".

For example - this is the text in the Access memo field:
"This is sentence one.
This is sentence two"

Turns into - this is the imported text in the Outlook message:
"This is sentence one.
This is sentence two"

The second example has a space character after the word "one" and the
first example does not" Normally this wouldn't matter but the grammar
check makes it look awful with its little green lines et the end of
each paragraph (and we want to keep the automatic grammar check on).

Here is the relevant code:

EmailBody = Nz(frm.Notes, "")
SendMessage Recp, RecpCC, RecpBCC, EmailSubject, EmailHeader &
EmailBody & EmailSig, NumAttach, EmailAttach()

Thanks in advance for any help.
Darleen

You may not really need to remove the spaces. When receiving an email, and
reading it, Grammar Checker is not looking over what the person sent. So the
extra space, like your example in this post, will never get seen/noticed.

Just a thought.

Sharkbyte




"leicklda" wrote:

Does anyone know how I can get an Access/Outlook translation to not put
a space character before each carriage return in a memo field? I am
populating my database's memo field "Notes" with the text I want to go
into my email. I then use the sendmessage command in VB to take this
text and put it into a new Outlook email. The problem is that once the
text goes into the email message, a space character has been inserted
at the end of each line which has a hard return in the memo field.
This space is definitely not there in the original memo field's text.
This dangling space character causes my Outlook grammar check to show a
little green line at the end of each paragraph which means "extra
space".

For example - this is the text in the Access memo field:
"This is sentence one.
This is sentence two"

Turns into - this is the imported text in the Outlook message:
"This is sentence one.
This is sentence two"

The second example has a space character after the word "one" and the
first example does not" Normally this wouldn't matter but the grammar
check makes it look awful with its little green lines et the end of
each paragraph (and we want to keep the automatic grammar check on).

Here is the relevant code:

EmailBody = Nz(frm.Notes, "")
SendMessage Recp, RecpCC, RecpBCC, EmailSubject, EmailHeader &
EmailBody & EmailSig, NumAttach, EmailAttach()

Thanks in advance for any help.
Darleen