Attach a file or email to a record?

[Guest]

Could anyone advise how I can attach a file or email to a record on a form?

 

[Guest]

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

 

[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.

 

[Guest]

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.

 

[Guest]

Thank you. This will help.

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

 

[Guest]

Thank you for your help!

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