Every week in my work, I email a snapshot of open jobs to another agency.

In the past I have used Access as our job database and then email the reports generated in HTML format. We are no longer permitted to use Access and as such now use Excel as our job database.

The other agency have asked that the jobs still be in HTML format. This has proved tricky for me to do but I have finally done it. Unfortunately, the size of the attachment is 7Mb!!!! Our mailbox limit for incoming and outgoing mail is 5Mb!

I use the code below to filter and send the required data.

How on earth can I reduce the size? Is it down to the coding or something else? Could I insert into the code a way of zipping the attachment or maybe copy and pasting it into a blank sheet to send? Or can I just get it to copy only the active area into the HTML?

The original size of the file is only 1.5Mb. Unfortunately due to the nature of the work, I am unable to attach it to this thread, nor would it be practical to knock up a dummy one without speding ages tailoring the details in it.

Please Login or Register  to view this content.