Zip excel worksheet and attach to an email

[crimzonclover]

Hi folks.. I'm relatively ok with navigating excel and using the VBA.

What I'm trying to do is zip one of the 2 worksheets in my workbook and attach it to an email.
So basically... the user would input information into Sheet 1, click a button, the information would fill in a hidden Sheet 2 and then zip it and attach it to an email.

I would also like to be able to be able to hard code the "To" and "Subject" field of the email.

HELP!!

Thank you in advance!

 

[BrianB]

Hopefully this will help with the ZIp bit
http://www.mrexcel.com/forum/showthread.php?t=294021

There is loads of code around for manipulating MS Outlook
search for CreateObject("Outlook.Application")