e-mails via access

robsafe · November 15th, 2003, 02:03 PM

In order to provide a unique number to each e-mail automatically I have set up an access 2000 database to sent e-mails via Outlook,however when then viewed in Outlook all the paragraph formating seen in Access has disappeared and the e-mails are a continuous stream of text. Also the following characters stop the database information transfering to Outlook " &
Can anyone help please I am fed up with reformating the e-mail prior to sending

U.N.C.L.E. · November 15th, 2003, 05:46 PM

What format message are you using? HTML, plain text, RTF?

What control are you using to write the message?

What data type are you using in your Access table?

U.N.C.L.E. · November 17th, 2003, 12:02 PM

robsafe,

As I suspected, a memo field is not really appropriate for formatted text, such as an email message body, as white space is stripped when stored in a memo field.

I recommend using an OLE Object (Wordpad Object) as the control on your form you use to enter the email message body. Of course you'll have to change the data type in your table to OLE Object.