Hello All
I have gone thru many posts in the newsgroup to lookup a solution to
my problem.

This is the scenario:

1) Path = C:\Reports\

2) File = *.xls

3) Filename = fn ln description.xls (fn = firstname, ln = lastname,
description = file description) eg John Clark Purchase Report.xls
(email would be )

4) Email address = (pls note the dot in between
firstname and lastname)

5) Generic Filename = two types in the folder having Product and
Supplier in the filename (eg Product Report for August.xls, Supplier
of Consumable.xls etc etc)

There are about 100+ users and the workbook is saved in the path above
with the user firstname lastname and description as mentioned in
Filename above.

I wish to have a macro which should lookup all Files in the Path and
send the workbook as email using Microsoft Outlook 2003 to the
respective users email address. All files have user firstname
lastname followed by description.

Eg John Clark Purchase Report.xls should be emailed to

Tim Kelly xxxx yyyyy.xls should be emailed to
…. …..
….. …..
Email address can be obtained from filename getting firstname
lastname

Generic Filename (having Product and Supplier in the name) will not be
sent to any users.

At the end it should display the message that the work is done.

In short
1) Open the first workbook in the path
2) Extract firstname and lastname from the file and put a dot in
between to get the email address of the user.
3) Send the workbook us MS Outlook 2003 to respective users but
exclude filename if it is Generic type.
4) Repeat for next workbook
5) Display message after the last file is sent.

Hope to get some assistance from experts.
Thanks

Rushna