Using access 2007 vba, I have a string of email addresses which have been extracted from access query. This query uses two tables, each of which contain email addresses.
I have copied the email addresses into a string (strRecipients), each email address seperated by semi-colon (;).
My problem is this string can contain duplicate email addresses.
Any ideas on how I would remove any duplicate email addresses, so the recipient will only receive one email.