Copying OE Address Book To Excel

  pypedream 23:23 12 Jan 2003
  pypedream 23:23 12 Jan 2003

Anyone know how to transfer a folder of addresses from Outlook Express to a spreadsheet such as Excel. My attemtps have so far generated a seperate sheet for each entry. All ideas are welcomed... my original intention was to print the contents of a folder of names with addresses from OE, but this seems difficult, so I tried to copy to a speadsheet.

  VoG™ 23:29 12 Jan 2003

Nope! But I do know how to do it with Outlook. You may be able to adapt the following code

Sub MakeContactList()

'write the default Outlook contact name list to the active worksheet

Dim OlApp As Object

Dim Contacts As Object

Dim i As Integer

Set OlApp = CreateObject("Outlook.Application")

Set Contacts = OlApp.getnamespace("MAPI").getdefaultfolder(10)

[a1] = "Index"

[b1] = "Contact Name"

For i = 1 To Contacts.items.Count

Cells(i + 1, 1) = i

Cells(i + 1, 2) = Contacts.items(i)

Next i

End Sub

  pypedream 23:35 12 Jan 2003

Pass go and collect £200, many thanks for your suggestion I'll give it a go, but I'm not up to your speed just yet! However I'll do my best!

  beeuuem 00:02 13 Jan 2003

You could try:-
Export your OE address book to a file as 'Text file comma seperated values'
Open this file from Excel, select text files from the drop down menu in the 'OPEN' window, and all the fields you exported should appear. You may have to manually adjust the field size

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

30 UK artists have created vibrant posters celebrating Pride London

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?