Email files automatically to a list of people, by looking for the email address and attachement name in an Excel list
Posted on 2004-11-16
Don't know if this is the right forum to ask this question. I am running Outlook 2002 and I am looking for a solution to automatically email a series of files to a group of people. There are about 100 files I need to send out each week and it would be great if I could do this automatically with a script.
I have an Excel file, called Master.xls. The file contains the following data, starting on row 2
A B C
Column A contains the names of the files stored in C:\Data; i.e CHI_John_Doe.xls, ATL_Jane_Smith.xls....
They are all Excel files.
What I'd like to be able to do is run a script that automatically sends an email to John_Doe@domain.com with CHI_John_Doe.xls as the attachement; another email to Jane_Smith@domain.com, containing ATL_Jane_Smith.xls, until all the file names in column A were processed.
Is this possible? I appreciate your help and ideas! I am an enthusiastic user of experts-exchange, although I haven't used the Outlook forum before. I don't have much experience with Outlook scripts and I don't know if what I am looking for is even possible.
Thanks so much!