Hi,

I have this scenario:

1. Weekly master file has few rows for each person.
2. Each person should get email with new data each week.
3. Splitting and sending should be in the background.

My approach:

1. Use PQ FROM FOLDER once to create file for each person from the master file.
2. When new master file arrive, place it in the folder.
3. Use VBA to loop through all persons' files to refresh and email them in the backgroud.

Is this the best/simplest approach?

Sample master file attached.

Regards,

Ayal Telem.