Emailing Attachment content within the report (1 Viewer)

Shetheikonic

New member
Local time
Today, 07:05
Joined
Nov 19, 2023
Messages
2
Hello,
i hope i get a solution for this one, am a beginner in access but i learn fast

i have a report linked to a table , one of the fields is Attachment field, which includes multiple attachments with different formats (word doc, img, pdf) the problem is when emailing the report it doesnt show the attachments if its anything other than images, only an icon of it, also when previewing it shows only imgs

is there a way to email the report along side all the attachments of a record
Screenshot 2023-11-19 143148.png

thank you in advance
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:05
Joined
Oct 29, 2018
Messages
21,581
Hi. Welcome to AWF!

You'll have to extract the attachments and add the files to the email as a separate process. This can be done using VBA.
 

Shetheikonic

New member
Local time
Today, 07:05
Joined
Nov 19, 2023
Messages
2
Hi. Welcome to AWF!

You'll have to extract the attachments and add the files to the email as a separate process. This can be done using VBA.
thank you for the fast response, can you guide me through this?
much appreciated
 

Users who are viewing this thread

Top Bottom