Emailing Attachment content within the report (1 Viewer)

[Shetheikonic]

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


thank you in advance

 

[theDBguy]

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]

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

 

[theDBguy]

thank you for the fast response, can you guide me through this?
much appreciated

You can see some sample codes here.

Work with attachments in DAO

Office VBA reference topic

learn.microsoft.com

Sent from phone...