Hi all, I have ListBox1 on my sheet and with one click of button I
get all the files names from specific folder into ListBox1 item list.
See below the example of files names.

Derek Williom.xlsm
John Robert.xls
Steve Wasten.xlsx
Jerry Ali.xlsm
etc…………..

I want macro on a button which should Send separate Emails and in each
email it should attache one file from ListBox1 items and put person's
name in email address (where it say "TO") which will be the characters
before the dot in file name. For example taking above files names lets
say i have these files names in ListBox1 and which i got from folder
"C:\Files". Because i have four files so i need to send four emails
and in first email i need "Derek Williom.xlsm" file to be attached and
in "TO" section i want the characters before the dot in file name so
in this case it will be "Derek Williom" and same thing i need with
other peoples email. Basically i want to send emails to people with
their name file attached. The files in list box can be 1 or 100 or
may be more. I hope i was able to explain my question. Please can
any friend can help.