INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

create and export a table to excell and automatically save

create and export a table to excell and automatically save

(OP)
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.

RE: create and export a table to excell and automatically save

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: create and export a table to excell and automatically save

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close