Zip file with Macro

[Guest]

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

 

[Steve Schapel]

Andy,

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