If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I insert/paste email into an Access form field
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! |
#2
|
|||
|
|||
Can I insert/paste email into an Access form field
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 "Diddakoi" wrote in message ... 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! |
#3
|
|||
|
|||
Can I insert/paste email into an Access form field
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" wrote: 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! |
#4
|
|||
|
|||
Can I insert/paste email into an Access form field
Danny -- you and Bob have suggested the same solution, so I will give that a
try and see how it works. Thank you! "Danny Seager" wrote: 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" wrote: 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! |
#5
|
|||
|
|||
Can I insert/paste email into an Access form field
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 |
Thread Tools | |
Display Modes | |
|
|