Attach email to record

[YNWA]

Hi,

Is it possible to either attach an email to a record or attach a word/text document to a record in access?

I have a simple user form that logs requests sent to an email account.

Would I be able to save these emails against their record by anychance?

Thanks
Will

 

[CBrighton]

At the very least you can have a field containing the location of the file, then you can easily access it in VBA using something like FollowHyperlink.

Depends how the rest of it works, are we talking Outlook automation? If so there is likely a command to save the email before you send it.

I've done something similar (used the standard windows open dialog using Access VBA to capture the location of files which I want to include as attachments on automated emails) but never tried to save an email via automation.