Outlook not importing to Contacts some data from Excel

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Hi, Outlook is not importing some contacts from my Excel spreadsheet and not
importing any postcodes. How do I get Outlook to import all the Excel rows
and put the postcodes in the postcode field?
 
Hello Jason,

Thanks for using Microsoft Newsgroup Support Service, my name is Ji Zhou
[MSFT] and I will be working on this issue with you.

Could you please be a little more specific about your problem. Is the issue
related to Outlook itself's function or related to programming with
Outlook/Excel object model? This newsgroup only targets at programming
issues. Actually, if we are trying to do this via codes, we can set the
post codes via ContactItem.MailingAddressPostalCode property. For example,
the following Outlook VBA codes return postal codes of all contact items
for me.

Sub Test()
Dim c As ContactItem
For Each c In Application.Session.GetDefaultFolder(olFolderContacts).Items
MsgBox (c.MailingAddressPostalCode)
Next
End Sub

So, if you want to import Excel rows into Outlook contacts, just loop
through the Excel rows, create contact items for every Excel record and set
the contact item's
MailingAddressPostalCode according to the specified column value.

Please let us know if this addresses your questions or concerns. If you
need any future help, please feel free to update this thread. Have a nice
day!


Best regards,
Ji Zhou
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.
 
Back
Top