VBA codes for zipping files and sending mails

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zipping files and using them in a program... Is it possible? 1
Dynamically Rename Files Using VBA 0
Enquiry for Ron de Bruin 15
Format Zip Codes Correctly for a Mailmerge 3
Exporting and Zipping Files with Access VBA 4
Need VLOOKUP to Work Two Ways 0
Automated zipping command 2
Sending MORE than one workbook AND using .CC and .BCC as well? 2

Top