VBA codes for zipping files and sending mails

  • Thread starter Thread starter Vijay Kotian
  • Start date Start date
V

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.
 
Back
Top