Exporting Attachments from Access tables

[RogerCooper]

I have PDF's in an Access table using the Attachment field, that I need to automatically export and attach to an e-mail. I would I do this in VBA?

 

[Gasman]

Save each attachment to a file, and attach that file to the email.

 

[sonic8]

I recorded a video on extracting attachments some time ago:

You then just need to attach the resulting file(s) to an email. There are many examples showing that.

 

[jdraw]

You may find some info at this older thread https://www.access-programmers.co.u...er-not-putting-attachments-in-folders.309573/

 

[DickyP]

Although not germane to the detail of this thread this Attachments problems link to a previous thread does show that the problems addressed by it are not worth the huge overhead if you have lots of attachments. It also goes against the niceties of Relational Database Design as its usage de-normalizes your data and makes any manipulation/investigation of your whole set of attachments difficult.

 

[RogerCooper]

I recorded a video on extracting attachments some time ago:

You then just need to attach the resulting file(s) to an email. There are many examples showing that.

Do you have the actual code you demonstrated available?

 

[DickyP]

Although not germane to the detail of this thread this Attachments problems link to a previous thread does show that the problems addressed by it are not worth the huge overhead if you have lots of attachments. It also goes against the niceties of Relational Database Design as its usage de-normalizes your data and makes any manipulation/investigation of your whole set of attachments difficult.

To put this in perspective I created a new database with just the books table and the attachments table from my Books database. This was 778,640 bytes, After adding the external attachment files pointed to by my attachments table into a new Attachments field in the book table the new database had grown to 44,949,504 bytes! Some bloat overhead.

 

[sonic8]

Do you have the actual code you demonstrated available?

Yes. Look in the video description. There is a download link.

 

[Gasman]

Yes. Look in the video description. There is a download link.

Not even bothered to look at the link? :-(

 

[Gasman]

Do you have the actual code you demonstrated available?

I recorded a video on extracting attachments some time ago:

You then just need to attach the resulting file(s) to an email. There are many examples showing that.

Excellent video. Thank you.

 

[cheekybuddha]

Not even bothered to look at the link? :-(

To be fair, you can watch the video directly in this page without going to YouTube, so the description/link is not apparent.

 

[RogerCooper]

It was not so easy to find the link, but I got it now.

 

[Gasman]

It was not so easy to find the link, but I got it now.

You could just as easy paused the video and added the code manually The code window is huge in that video and easy to read.
That way you would learn as you go.?

 

[Gasman]

To be fair, you can watch the video directly in this page without going to YouTube, so the description/link is not apparent.

I need a bigger screen with my eyes.

 

[cheekybuddha]

I need a bigger screen with my eyes.

Fullscreen button in bottom right of embedded video window?

 

[Gasman]

Fullscreen button in bottom right of embedded video window?

Thank you.

 

[cheekybuddha]

Thank you

Of course you then miss the all-important link, so sometimes ignorance is bliss!