[email protected] wrote:
I remember doing this in dBase+ back in the 80's, as I recall it
required a macro.
Could this be done in something like OpenOffice with a macro?
If I were faced with this need today, I would export both lists to
csv format, import them into http://google.com/contacts then run the
google contacts dedupe process and export them when finished.
Beverly Howard
It still works in the current incarnation of dbase+ that I use which is
FoxPro.
1. create a database called ADDRESS with fields of "NAME", "EMAIL" and
"COUNT"
2. Import from various address book .csv files the variables "NAME" and
"EMAIL" into database ADDRESS
3. use ADDRESS
4. Replace all count with 1
5. Index on email to email
6. set orde to email
7. Total on email to NODUPE
8. Use NODUPE
9. list name,email,count
A single instance of each email will be shown in the file NODUPE. The
number of occurrences for each email will be shown in the variable COUNT
which will usually be 1
10. copy to NODUPECSV type delimited with ,
11. import NODUPECSV into your mailer's address book.
I tried to find a way to do this in OpenOffice 3.2 but did not see an
easy way to do it.
_______________________________________________
support-seamonkey mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-seamonkey
