davidchipman
Programmer
Hi
Hope someone can help. I have a created an access database by exporting information from an accounting database that was already established. My problem occurs as I have numerous companies with unique ids, but one person can be the main contact on many of these companies. We are trying to do a mail merge in word but i do not know how to supress these duplicates. (ie Person A is the contact on 9 companies, we do not want to mail this individual 9 newsletters) The set up of this old database was inefficeint for this purpose and can not be changed at this time as there is numerous clients in it and is not an option. I was wondering if there is anything that can be done to supress these duplicates. Thanks
Hope someone can help. I have a created an access database by exporting information from an accounting database that was already established. My problem occurs as I have numerous companies with unique ids, but one person can be the main contact on many of these companies. We are trying to do a mail merge in word but i do not know how to supress these duplicates. (ie Person A is the contact on 9 companies, we do not want to mail this individual 9 newsletters) The set up of this old database was inefficeint for this purpose and can not be changed at this time as there is numerous clients in it and is not an option. I was wondering if there is anything that can be done to supress these duplicates. Thanks