Call Outlook from Excel macro

[Tracey]

I have a macro that creates an xl spreadsheet and then zips the file as we
have an Outlook size limit.
Can I code the macro to then call Outlook, insert a recipient name and
subject and then wait for me to attach the zipped file??

Thanks in Advance
--

 

[Ron de Bruin]

Hi Tracey

See the last example on this page
http://www.rondebruin.nl/windowsxpzip.htm

For WinZip see
http://www.rondebruin.nl/zip.htm