Outlook & excel

  • Thread starter Thread starter nmw
  • Start date Start date
N

nmw

How does one transfer data from an excel mailing list into
outlook? Your help would be greatly appreciated. Thanks,
 
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
 
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
 
Back
Top