Hi Tony,

To email from vba, look at Ron de Bruin's sendmail code at:
http://www.rondebruin.nl/sendmail.htm


For winzip, I found this in the newsgroup from May 2004:

From: (il_magpie)
Date: 7 May 2004 10:21:49 -0700
Local: Fri, May 7 2004 9:21 am
Subject: Opening zipped *.xls from Excel

Hi All,

I am trying to let the user open a zipped Excel file (using Winzip)
from Excel, without any success.

Excel itself won't let you drill down into a zipped folder to extract
a file, so am not very hopeful that this can be accomplished through
VBA. Any suggestions?

Thanks!

Newsgroups: microsoft.public.excel.programming
From: "Ron de Bruin"
Date: Fri, 7 May 2004 19:34:38 +0200
Local: Fri, May 7 2004 9:34 am
Subject: Opening zipped *.xls from Excel
Reply to author | Forward | Print | Individual message | Show original
| Report this message | Find messages by this author
Hi

One way

You can use shell to unzip the zip file if you find them
You need this Add-in
http://www.winzip.com/wzcline.htm

Try this for unzip test.zip from to C:\

Sub test()
Shell "c:\program files\winzip\wzunzip c:\test.zip c:\"
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl


Dan