MacroScope
Programmer
I have a database that has many contacts from many companies. One company has 145 contacts in it, others have 1-5, some others up to 40. I am emailing them in small groups and I want to only email one person from each company with each mailing. As a contact receives an email a Sent checkbox is set to true, so it's easy not to duplicate individuals, but my problem is to create a list that only has one name from each company (whose Sent field is false).
Does anyone have a suggestion on how to accomplish that?
As always, all help will be appreciated.
Does anyone have a suggestion on how to accomplish that?
As always, all help will be appreciated.