automatically check whether I have sent an email address to a person

[Zweibel]

I have a very long list of email addresses (partly in my contacts) and
before I send an email I must know whether I have already sent an
email to a person in this list.

Is there anyway this can be automated?

 

[John Blessing]

Export the list of "already sent" and the others to a text file, then use a
mailing list program that has a duplicate elimininator.

Anything else is either more complex (e.g. export to a database and run a
select not in query) or more tedious (e.g. manual comparison)

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters
http://www.repeatmail.com - Send individual emails, scheduled or one-off,
plain or html

 

[Diane Poremsky [MVP]]

you can do it fairly easily in Excel. paste all the addresses, sort
alphabetically then use an IF formula that compares two cells, if the same
the cell is blank, if not the same, use the contents of the first cell -
=IF(A1=A2,"",A1). Then copy and use paste special, values to convert the
formula to hard data and paste into the address list to be used for the
mailing.

You can get the addresses from Outlook by copying a custom view:
http://www.outlook-tips.net/howto/copy_data.htm