Solved

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

Posted on 2013-12-01
12
428 Views
Last Modified: 2013-12-02
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
Comment
Question by:John Goodger
12 Comments
 
LVL 13

Expert Comment

by:duncanb7
Comment Utility
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
 
LVL 42

Expert Comment

by:Rob Jurd, EE MVE
Comment Utility
0
 
LVL 34

Expert Comment

by:Dan Craciun
Comment Utility
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
 
LVL 2

Expert Comment

by:Moses
Comment Utility
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
 

Author Comment

by:John Goodger
Comment Utility
I have never heard of Plaxo but it sounds like it might be right for me?
Any more on Plaxo appreciated
0
 
LVL 2

Accepted Solution

by:
Moses earned 150 total points
Comment Utility
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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:John Goodger
Comment Utility
Plaxo looks good but I want a cost free solution
0
 
LVL 2

Expert Comment

by:Moses
Comment Utility
It is free unless you want VIP support.
0
 

Author Comment

by:John Goodger
Comment Utility
Oh - I only saw a monthly fee on their website
0
 

Author Comment

by:John Goodger
Comment Utility
So sorry I now see the Basic package is free
0
 

Author Comment

by:John Goodger
Comment Utility
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
 

Author Closing Comment

by:John Goodger
Comment Utility
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Steve Jobs once said that Blu-ray is "a bag of hurt". As Macs users well known, things haven’t settled down (at least not from Apple’s perspective). Several years after that comment, Mac OS X still doesn’t support Blu-ray playback, nor has any Mac s…
Are you looking to clear some space on your phone for the latest iOS 8 update? Did you switch to Spotify so you no longer need to keep music native on your phone? Run out of space for taking photos while in the middle of vacation? Sometimes the quic…
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now