Email addresses to outlook

[Vokain]

Hi Guys

I have a spreadsheet with a row full of email addresses C1:C1300 many of them are duplicates (i.e. c4 is the same as c6 and c7 etc)

First of all I would like to create a unique list of them (i.e only to list each of the addresses once) so the list will be a lot shorter lets say only 700 rows.

Now after this is done I would need somehow to export this list to Outlook.

Any ideas how to do this?

Thank you

 

[VoG]

You can use Advanced Filter to generate a list of uniques http://www.contextures.com/xladvfilter01.html#FilterUR

Then see http://www.rondebruin.nl/mail/importcontacts.htm