VBA photo/image compression

I am wondering if this is possible and within the realms of Access?

I currently have a database system where the user can open up directories/folders related to the record; such as images, docs etc... This avoids bloat by attaching the images to the records and what not, and works fine.

A user enhancement would be to allow the user to automatically compress photos so that they are more appropriate in file size to attach to emails.

I was wondering if it would be possible to, say whilst using the FileSystemObject and CopyFile, copy the photos from one folder (/photos) to another folder (/compressed_photos) and compress them at the same time.开发者_如何学编程

Could I use "VBA.Shell" and run a batch image compression program on the photos?

Any advice on the above is greatly appreciated, even if it is just to confirm that it is not possible.

Cheers Noel

A simple solution would be to use ImageMagick via Command Line. See the examples on the manual pages there.