[Creating a letter with specific names]

Thank you. This looks like it could be way over my head.

 

I only use FP for simple jobs that require some personalized fields and numbering tickets.

 

Thanks again.

[Creating a letter with specific names]

So I have a project where I need to pull names and place them on a letter.

 

I have an Excel file with 3500+ names. Those names are sorted by office number of which there are 360 offices.

 

Sounds simple enough, right? Well here's where it gets a little difficult.

I have to place only the names of the people who are in the same office on the same letter. So when I'm done I need to have 360 letters and each letter can only have the names of the people who are in that specific office listed in a column.

 

My data looks something like this:

 

FIrst Name Last Name Office Number

Tom Jones 001

Lisa Jones 001

Billy Jones 001

Joe Smith 002

Howard Evans 002

Mark Swan 003

Tina Epstein 004

George Winston 004

Wallace Morgan 005

 

So how can I pull only the people from Office Number 001 and have their names listed (in a column) on one letter and then have only the people from Office Number 002 and list just them and so on and so on...

 

I am using Fusion Pro Desktop 7.2

 

Thank You!