Zip file with Macro

A

Andy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing double quotes from field names 0
Difficulty with compatibility mode and Track Changes 2
Send object function with a CSV file 4
Want Macro to save to .xlsx 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
VBSript to read multiple CSV files & write out to 1 CSV file 10
VBScript that read multiple CVS file in multiple folder & writes o 0
VBScript to read multiple CSV files pull some data from each and w 0

Top