On Feb 18, 11:59*am, Joel wrote:
This sounds like it would be better as an Outlook VBA Macro rather than an
Excel VBA Macro. *Even though the files are excel files it would be better as
an email solution. *You probably have Outlook opened on your PC and it would
be simplier to just push a button in outlook than to open an excel file and
run a macro.



"K" wrote:
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.- Hide quoted text -

- Show quoted text -

Hi Joel thanks for replying. I dont need any macro on Outlook. This
has to be done in excel. it is important for my project.