asked on

Extract File list / corresponding File size in a directory

I would like to create a template (output could be text file or pasted directory to corporate email message using Outlook 2000) for an email notification of data transmission. The idea is to list all files in the source path with their corresponding file sizes. The source path is D:\4xmit\final\Today's Transmission wherein you would be able to locate the LET, TXT, ZIP, $$$, and XLS files, while image files (TIF files) can be located in 2 subfolders: D:\4xmit\final\Today's Transmission\black images, and D:\4xmit\final\Today's Transmission\white images.

What I would like to do is place the listing of LET and TXT right after the header "ftp.company.co.us\textandletfiles" (LET and TXT files can be found at "D:\4xmit\final\Today's Transmission" folder);

TIF files either at the following two headers: ftp.company.co.us\white images or ftp.company.co.us\black images, depending on where they can be found at D:\4xmit\final\Today's Transmission\black images or D:\4xmit\final\Today's Transmission\white images;

$$$ files after the header "ftp.company.co.us\billing" ($$$ files can be found at "D:\4xmit\final\Today's Transmission"; and

ZIP and XLS files after the header "ftp.company.co.us\quality" (ZIP and XLS files can be found at "D:\4xmit\final\Today's Transmission"

To illustrate, a template is provided below:

============================================================
Dear Sir:

We are pleased to inform you that the following files are already available in your FTP for your soonest receipt:

ftp.company.co.us\textandletfiles
textfile1.txt + filesize
letfile1.let + filesize
textfile2.txt + filesize
letfile2.let + filesize

ftp.company.co.us\white images
whiteimage1.tif + filesize
whiteimage2.tif + filesize
whiteimage3.tif + filesize

ftp.company.co.us\black images
blackimage1.tif + filesize
blackimage2.tif + filesize
blackimage3.tif + filesize

ftp.company.co.us\qualitysheets
excelfile1.xls + filesize
excelfile2.xls + filesize
zipfile1.zip + filesize
zipfile2.zip + filesize

ftp.company.co.us\billing
dollar1.$$$ + filesize
dollar2.$$$ + filesize

Should there be any problem, please don't hesitate to give us a call.

Warm Regards,

John

============================================================

Can anyone help me on this?

Thanks,

John

ASKER CERTIFIED SOLUTION

ramesh12

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

johndacs

ASKER

ramesh12,

I'm gonna increase the points if you can give me the complete code. I'm not that well-verse in either Visual Basic or VBA.

Thanks,

John

DarkoLord

No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:
Accept ramesh12's comment as an answer

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

DarkoLord
EE Cleanup Volunteer