I am trying to figure out the best way to handle this project. I would like to accomplish it through VBA which seems to be the obvious simplest way. I know I can do it manually but that seems to take more time. Here is the facts.
Suggestions on how to start this project would be nice. Thanks!
1) There are more than 3400 records.
2) Each record belongs to one of 49 communities (subdivisions)
3) Need to save each of the 49 communities into their own CSV file.
4) I have 4 columns currently setup as Subdivision, Name, Address and Phone.
5) I am working on a mail merge to place into a community phone directory.
2) Each record belongs to one of 49 communities (subdivisions)
3) Need to save each of the 49 communities into their own CSV file.
4) I have 4 columns currently setup as Subdivision, Name, Address and Phone.
5) I am working on a mail merge to place into a community phone directory.
Suggestions on how to start this project would be nice. Thanks!
