Hi
I have folder used to dump excel files in, lets call them Client1.xlsx, Client23.xlsx,Client38.xlsx, Client57.xlsx etc
I have a dataset with those client names and email adresses in my QV doc:
Im looking for a macro that will when executed do the following:
1. List and associate all files in the folder wtih the Client field
2. Attach each excel file individually to an email and send it to the associated Email field. (i want the macro to contain the mail server settings and send the email direct,not via Outlook etc)
I have scouted and searched without luck, my macro ends up sending Client1 to one but when it comes to the last client it attaches all the excel files, any help?