Outlook - Emails

[Matt_Chelmsford]

Hi,
I am trying to devise a database where in a field I can c+p the contents of an email. However, the problem with this is that there is a restriction on the number of characters.
Is there any way I can attach an email to an entry in a database so that when a person looks at a particular record they can see any corresponding email.
Regards

 

[dk]

Hi

What is the restriction you're talking about? If you use the Memo type field in your table then this can store about 64,000 characters, which would be a fairly sizable email message. If you wanted to store more than that then you'd probably have to break down the message into chunks so you'd have something like a MESSAGE_HEADER table (where you store things like recipients, date, subject) and a MESSAGE_DETAIL table (where you store the text of the message).

HTH
DK