Thanks for the code Joel but I don’t think this is what I am looking
for. I think I haven't explained my question properly. I thought if
I'll ask small questions instead of big question then it would be easy
to get an answer. Please let me expalin again that what I am trying
to do. I got two ListBox and Three Buttons on my Sheet. Button1
caption is "Get Files from Folder" , Button2 caption is "Transfer" and
Button3 caption is "Send Mail". When I click on Button1 I get Browse
Folder window in which I select desired Folder and when I press OK on
it I get all the files names in that Folder appeared in ListBox1.
After this I select the files names in ListBox1 the one I am after and
then I click on Button2 which then transfer those selected files names
items into ListBox2. Now I need macro to assign to Button3 which
should saparately Send Mail according to the items in ListBox2 (in
other words if i have two items in ListBox2 then send two mails if i
have ten then send ten mails etc). In each Mail each file (which names
are showing in ListBox2) should be attached and in "TO" section of
Mail macro should put names exracting from attached file name. Please
do help if you can.