p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   e-mails via access (http://p2p.wrox.com/showthread.php?t=6205)

robsafe November 15th, 2003 02:03 PM

e-mails via access
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


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.

All times are GMT -4. The time now is 02:26 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.