M
Marty
Could anyone advise how I can attach a file or email to a record on a form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Ventouris
In A2007, create and a new field in the underlying table and select FieldType
Attachment. Put this filed on your form and click for the attachment
dialogue. This is a Multivalued Field and you will not be able to export the
contents to another DB.
For earlier versions, consider using hyperlinks and storing the attachments
outside the DB
Attachment. Put this filed on your form and click for the attachment
dialogue. This is a Multivalued Field and you will not be able to export the
contents to another DB.
For earlier versions, consider using hyperlinks and storing the attachments
outside the DB
T
Tom van Stiphout
On Mon, 5 Nov 2007 15:55:00 -0800, Marty
Access2007 has new support for attaching files to a record. You'd use
the new ACCDB format, and the Attachment data type.
No way to attach an email. Your next best choice may be to add the
body of the message to a memo field. If it is really important to have
the exact email with all its formatting and attachments, I would look
into keeping the email in Outlook/Exchange and storing a unique email
identifier so you can look it up again later.
-Tom.
Access2007 has new support for attaching files to a record. You'd use
the new ACCDB format, and the Attachment data type.
No way to attach an email. Your next best choice may be to add the
body of the message to a memo field. If it is really important to have
the exact email with all its formatting and attachments, I would look
into keeping the email in Outlook/Exchange and storing a unique email
identifier so you can look it up again later.
-Tom.
T
Tom Ventouris
One way to attache email to the DB......
Select the e mail message.
Click File-Save as
Give it a name and select Outlook Message Format Save
Open the DB and attach the file
From here, when you open it will open in Outlook, looking like it did when
it arrived.
Select the e mail message.
Click File-Save as
Give it a name and select Outlook Message Format Save
Open the DB and attach the file
From here, when you open it will open in Outlook, looking like it did when
it arrived.
M
Marty
Thank you. This will help.
Tom Ventouris said:In A2007, create and a new field in the underlying table and select FieldType
Attachment. Put this filed on your form and click for the attachment
dialogue. This is a Multivalued Field and you will not be able to export the
contents to another DB.
For earlier versions, consider using hyperlinks and storing the attachments
outside the DB
M
Marty
Thank you for your help!
Tom Ventouris said:In A2007, create and a new field in the underlying table and select FieldType
Attachment. Put this filed on your form and click for the attachment
dialogue. This is a Multivalued Field and you will not be able to export the
contents to another DB.
For earlier versions, consider using hyperlinks and storing the attachments
outside the DB