Excel macro to open an office form

Hello All,

I have recently wrote a macro to Zip the current spreadsheet I am working on. However was wondering if it is possible to further this, by adding in a bit to then find this zip file and attach it to a specific form in office outlook.

I currently work with a lot of information, that has to be sent to several distribution lists.

Any help would be much appreciated.

Thanks

Marc