VBA codes for zipping files and sending mails

[Vijay Kotian]

Hi,

I have few files in one of the folder, I would like to zip files and send it
through mail. the zipping of the files has to be done based on starting few
similar characters in the file name e.g.

ABCDEFGHITrans.xls
ABCDEFGHIhold.xls
ABCDEFGHIvalue.xls

I would like to zip one set of files whose names are starting with
ABCDEFGHI**** as ABCDEFGHI.zip and delete the original files and similarly
other set of three files starting with .......... so on and so forth.

Can anybody help me with VBA codes.

Thank you.

 

[Joel]

Use Ron Debruin code. See attached webpage. He has one section for sending
email another for zipping files

http://www.rondebruin.nl/tips.htm

 

[Ron de Bruin]

There is a combo Zip/Mail macro here

Windows zip program
http://www.rondebruin.nl/windowsxpzip.htm

If you use Winzip
http://www.rondebruin.nl/zip.htm



--

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