Call Outlook from Excel macro
 

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
--

Call Outlook from Excel macro
 

Hi Tracey

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Tracey" wrote in message ...
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
--