Can I insert/paste email into an Access form field

[Diddakoi]

I am using Access 2003. I created a form and from time to time I'm finding
myself wishing I could insert/paste an email into a miscellaneous notes field
I have created within the form.

I maintain a database of grant submissions and when one is in pending
status, there is useful information contained in an email, pertinent to the
record itself, that I would like to keep in the form until the submission
status changes one way or another. I often only need the email temporarily;
my thinking is that it would be a lot more convenient to view an
attached/inserted email with the author's own words (which is often more
lengthy that space allows) rather than recreate the context of it in an
abbreviated way in the miscellaneous notation area.

Any suggestions very much appreciated!

 

[Bob Larson]

You can create a field of a MEMO data type and then can copy the contents of
the email to the clipboard and paste into the field. Actually inserting the
email itself would probably not be efficient.


--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

 

[Danny Seager]

what problem are you having?

you should be able to just add a memo field to the table and bind it on the
form to a text box

 

[Diddakoi]

Danny -- you and Bob have suggested the same solution, so I will give that a
try and see how it works.

Thank you!

 

[Ron2006]

One way:

change the datatype to memo for that field (or add another field of
datatype memo) and copy/paste the body of the email into that field.

Another way.

Create either a directory/subdirectory for that issue (or less
usefull) a directory for all emails, and copy (drag and drop) the
entire email into the directory and then save the email name (that it
saved as) into a field in the table.

The advantage of the the name being in a separate field is that you
could then use a double click of the name to open the email.

The key is being able to know what directory/subdirectory and finally
name the email is in.

The disadvantage of both (and no easy way around it) is that some
users will try to paste the email itself into the field and that
basically will NOT work as far as I know.

Ron