Outlook Express and Access 97

[Rick Brandt]

I am looking for a way that Access 97 can send a carriage return when
sending data to Outlook Express. The code I am using is using Send
Object. I thought about using Word, but since he uses OE, my guess
not everyone has Office.

My client uses Access 97 (Pre-built application) and Outlook Express
as his email. I did recommend using Outlook as his email since OE
does not accept VBA code.

I have the values writing to Outlook Express, but I just need to
figure out how to send a carriage return other than VBA. If this
can't be done, then I will tell my client his info will be one
continous line or get everyone who will be using the Send Mail option
Outlook 2003.

If you put line feeds into the message text then they should appear in Outlook
Express. Unless OE is taking your text and using it in the body of an HTML
email in which case you would have to replace all cr-lf with <br>.

I have never seen SendObject create anything but a plain text message body
though (or at least one that is rendered as if it were plain text).

 

[GVaught]

I am looking for a way that Access 97 can send a carriage return when
sending data to Outlook Express. The code I am using is using Send Object. I
thought about using Word, but since he uses OE, my guess not everyone has
Office.

My client uses Access 97 (Pre-built application) and Outlook Express as his
email. I did recommend using Outlook as his email since OE does not accept
VBA code.

I have the values writing to Outlook Express, but I just need to figure out
how to send a carriage return other than VBA. If this can't be done, then I
will tell my client his info will be one continous line or get everyone who
will be using the Send Mail option Outlook 2003.

 

[GVaught]

Yes it send plaint text, which is okay by the client.
The piece of code I was trying to remember and found elsewhere is Chr$(13).

Now I just need to have my Outlook quite overriding my OE. I set OE as
default and Outlook seems to override regardless.

Thanks for your help Rick.

 

[Bill]

I use Lyle Fairfield's code to send e-mails where OE is the e-mail
client. You can download his code at:

http://ffdba.com/downloads/Send_Mail_With_Outlook_Express.htm

You'll have to look at whatever restrictions Lyle imposes regarding
commercial application and/or distribution of his code. I think it's okay
if it's compiled into your front-end mde, but again, you'd need to check.

Bill