Emailing embedded record attachments

[Thompyt]

How do I email embedded attachments in records (Attachment field) as a separate entity in the same email as the report being emailed?

Thanks

[June7]

This requires code that extracts the attachment and saves it externally then attaching to email message. Then can delete the external copy.

All can be done with VBA. Has been discussed in numerous threads. Here is one http://access.mvps.org/access/lookupfields.htm

[Thompyt]

That is for look up fields.

[June7]

Sorry, forgot to copy URL: https://www.accessforums.net/access/...orm-42994.html