• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

Convert ALL CSV Outlook 2010 Contacts into VCF for imac address book

I would like to be able to convert all ( 400+ ) Contacts on my PC to VCF files to add to my iMAC / iCloud Address book.
I can do them individually but I wish to do a bulk  conversion.
0
John Goodger
Asked:
John Goodger
1 Solution
 
duncanb7Commented:
Probably, you need to do it on VBA instead of doing manually convert
outlook contacts into vcf format.
And the following code is just providing your starting since that might have
a lot of  issue caused by  different system. You need to solve & debug  it by yourself

Hope understand your question completely.If not , please pt it out

Duncan
'Option Explicit

Sub Export_PAB_to_vcfs()

Dim myOlApp As Outlook.Application
Dim objContact As ContactItem

Set myOlApp = New Outlook.Application

Set olns = myOlApp.GetNamespace("MAPI")

' Set MyFolder to the default contacts folder.
Set myFolder1 = olns.Folders("Sean O'Reilly")
Set myfolder = myFolder1.Folders("Contacts")

' Get the number of items in the folder.
NumItems = myfolder.Items.Count

' Loop through all of the items in the folder.
For i = 1 To NumItems
    Debug.Print myfolder.Items(i).Class
    If myfolder.Items(i).Class = 40 Then
        Set objContact = myfolder.Items(i)
        Debug.Print TypeName(objContact) + ":" + objContact.FullName
        If Not TypeName(objContact) = "Nothing" Then
            If Not objContact.FullName = "" Then
              strname = "H:\Personal\Contacts\" & TrimALL(objContact.FullName) & ".vcf"
             objContact.SaveAs strname, olVCard
            End If
        End If
    End If
Next

MsgBox "All Contacts Exported!"

End Sub

Sub TrimALL()
' need to trim all non-printable char

End Sub

Open in new window

0
 
Dan CraciunIT ConsultantCommented:
You can install Thunderbird with the MoreFunctionsForAddressBook add-on, import automatically your Outlook contacts and then export them as vcf (Address Book->right click Imported Contacts->More Functions for Address Book->Export->As vCard)
No script needed...

HTH,
Dan
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
MosesCommented:
I use Plaxo to sync my Mac Address Book and my Outlook 2010 contacts. Check that option.  That way you do not have to do any export/import.  Works!
0
 
John GoodgerRetiredAuthor Commented:
I have never heard of Plaxo but it sounds like it might be right for me?
Any more on Plaxo appreciated
0
 
MosesCommented:
Go to http://www.plaxo.com

I have been using that service for more than a decade to keep my contacts synchronized and backed up. I Use it to sync to my PC/Mac/iPhone/iPad.
0
 
John GoodgerRetiredAuthor Commented:
Plaxo looks good but I want a cost free solution
0
 
MosesCommented:
It is free unless you want VIP support.
0
 
John GoodgerRetiredAuthor Commented:
Oh - I only saw a monthly fee on their website
0
 
John GoodgerRetiredAuthor Commented:
So sorry I now see the Basic package is free
0
 
John GoodgerRetiredAuthor Commented:
I also found a low cost application that does the job very well
http://www.littlemachines.com/download.php?lm=1386023164

Little machines O2M
0
 
John GoodgerRetiredAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now