Outlook & excel

N

nmw

How does one transfer data from an excel mailing list into
outlook? Your help would be greatly appreciated. Thanks,
 
P

Peo Sjoblom

In Outlook File>Import and Export>import from another program or file, next,
Microsoft Excel.
Far from being an expert when it comes to Outlook, you might find better
advice in an Outlook NG
 
H

Harald Staff

Hi

If you know what's what (phone fields, whatever) then you can import it by a macro like
this:

Sub AddContact()

Dim Myitem As Outlook.ContactItem
Dim OLF As Outlook.MAPIFolder

Set OLF = GetObject("", _
"Outlook.Application").GetNamespace("MAPI"). _
GetDefaultFolder(olFolderContacts)

Set Myitem = OLF.Items.Add

Myitem.LastName = "Doh"
Myitem.FirstName = "John"
Myitem.JobTitle = "Boss"
Myitem.Department = "Accounting"
Myitem.CompanyName = "Enron"
Myitem.BusinessTelephoneNumber = "N/A"
Myitem.Business2TelephoneNumber = "N/A"
Myitem.HomeTelephoneNumber = "N/A"
Myitem.MobileTelephoneNumber = "N/A"
Myitem.Save

Set Myitem = Nothing
Set OLF = Nothing
End Sub
 
Top