I have a tricky one - removal of duplicate records.

I have a Workflow that determines whether or not to post a letter or send an email, which is conditional on whether or not an email address exists.

However, there are occasions where, if the same email address exists in the data more than once, I would like to send a letter and not several emails.

Any ideas/help would be appreciated thanks.