create and export a table to excell and automatically save

[deek_1]

I am new to this so sorry . I need to send out 300-350 letters to suppliers with a list of their customers.Is there a way to take each supplier's list of customers and export to excel and save it. for example here is mock up of my table:
Customer id Cust name supplier number
9123456 chaz day care 2344
9123457 bill day care 2345
9123458 abc day care 2455
9123459 xyz day care 2456
9123460 bcd day care 2456
9123461 456 day care 2456
9123462 365 day care 2456
9123463 123 day care 2456

What I would like to have done is for supplier 2344 it will save in excel as customer list for 2344, then another in a separate spreadsheet as customer list 2345, then 2455 and so on.

I can complete a mail merge and then link to the specific customer list in the letter and I know how to perform that function it is building the spreadsheet/table and exporting is what I need help with.

Thank you.

 

[SkipVought]

Hi,

Do you REALLY need 300 separate files? Is it for archival reference or an active reference of customers per supplier? Why not a table that can be filtered by supplier?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[deek_1]

I believe I do since I need to assign a path in the mail merge which will link to the list of customers specific to each supplier.

https://www.youtube.com/watch?v=mJMXlRhC4Yw.

this is a what i will be doing with the files.