On Mon, 12 Jul 2004 05:32:31 -0700, "John"
wrote in
microsoft.public.excel.programming:

Hi Norman,

That is what I have tried to begin with.
I am getting an error in the following:

'Zip the file
ShellStr = PathWinZip & "Winzip32 -min -a" _
& " " & Chr(34) & FileNameZip & Chr(34) _
& " " & Chr(34) & FileNameXls & Chr(34)
ShellAndWait ShellStr, vbHide

I am using this Unregisterd WinZip(R) Version 8.1?

AFAIK WinZip32 does not support any command line switches - its command
line adjunct, WzZip, does; to avoid nag messages you probably need the
registered version, or a dfifferent free console zip program.

saving the file is also not working and attaching the file
is also not working.
I am using Window 2000 and MS Oulook 2000.

-----Original Message-----
Hi John!

See:
Ron de Bruin:
http://www.rondebruin.nl/sendmail.htm

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"