Excel File Email

Thu, 27 Aug 2015 12:48:53 GMT

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:

Client	Email
Client1	one@email.com
Client23	twenty3@email.com
Client38	three_eight@email.com
Client57	57@email.com
Client90	mr90@email.com

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?

topic Excel File Email in QlikView

Excel File Email