Hi,

Can someone help me create a code that zip, send and than
mail (attached the zipped file) workbook to several
recipients?

Regards

Hi John!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

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?

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

Regards,


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

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia



.

On the page at Ron's site it says:

The examples are only working If you use WinZip as your Zip program.(Note:
you must have a registered copy of WinZip)
-- Regards,Tom Ogilvy"John" wrote in
message ...
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?

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

Regards,


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

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia



.

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"

Hi John!

You've got the reason and bad news from Tom and Michael.

You may have noticed with your unregistered version that it opens
differently each time.

Although, the WinZip mailing process requires a Registered version of
WinZip, this does not impact upon the ability of receivers to use an
unregistered copy of WinZip to on zipped files.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

If you got UltimateZip (free for noncommercial home use)
http://www.ultimatezip.com/index.htm
hthttp://www.ultimatezip.com/download.htm

you would simply right-click on the file in Explorer, no special proprietory
GUI interface, and email it.
Zip and E-mail "filename".zip
you do not need to use VBA to help you do anything
But if you did it does have batch commands.

Backup to CD by zipping personal folders (#backupto_CD)
http://www.mvps.org/dmcritchie/excel/backup.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"John" wrote in message ...
Hi,

Can someone help me create a code that zip, send and than
mail (attached the zipped file) workbook to several
recipients?

Regards

I was looking through UltimateZip stuff, 2.7.1 the current version does
not support batch files after all (the author indicated in a forum that they
were working on it). There is a 3.0 Beta available, don't know if it has
batch processing or not (for myself, I don't care).