Zip file with Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy - 22 Aug 2006 11:43 GMT

I am currently using a macro to export a table as a .csv file and sending the
resulting .csv. Unforuntately the size of the .csv file is reaching 7MB our
internal attachment size limit. Is there anyway I can use a function to
winzip (or other comperssion) of the .csv file prior to using 'SendObject'?

Don't want to get into writing a batch file for WinZip!!!

Thanks

Reply to this Message

Steve Schapel - 22 Aug 2006 20:19 GMT

Andy,

Not in a macro. But there is some information for you here...
http://www.members.shaw.ca/AlbertKallal/zip/index.htm

Signature

Steve Schapel, Microsoft Access MVP

> I am currently using a macro to export a table as a .csv file and sending the
> resulting .csv. Unforuntately the size of the .csv file is reaching 7MB our
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message