[Resolved] Export addresses from Excel to Outlook

[c03cg]

Im writing a small function in VBA in Excell to create an Address book in Outlook 2003 from the list of staff names & addresses in an Excell spreadsheet.

It needs to be done this way as the software in use to store the staff details can only output to a .csv file.

Im thinking i have to do somthing along the lines of:

Dim oApp As Outlook.Application
Dim oAddress As Outlook.AddressList 'Is this correct?
 
Set oApp = New Outlook.Application
Set oAddress = 'Not entirely sure of how to assign this

And then read through each line of the spreadsheet creating entries?