Access DB, Sync Contacts to Outlook.com (via outlook or other method)

Stead

New member
Local time
Today, 15:56
Joined
Jul 24, 2014
Messages
3
Hi,

just wondering, has anyone here managed to programmatically add/retrieve contacts from an live account?

We are using outlook.com to sync contacts across our devices, since we are using windows phone I thought using one live account might simplify things

I've written code to copy across the contacts to outlook, but I can only get it to go to the default contacts folder. So far I've just been deleting all contacts then manually copying them over, the only problem is this takes a few hours to follow through onto the phones, not the end of the world, but it would be much nicer for it to be done automatically.

is there a special way to get it to work with an exchange/active sync contacts list?

another question I can't seem to find an answer for, is it possible to work with outlook contacts as record set, we have approx 3,000, and so far when a change is made to a record on our db, it will search every contact (for each changed record) then update the one that matches with its unique id, seems a bit of a slow way to do things, was hoping there was another way, I've seen examples of loading all the contacts into a record set, but the only way I can see would then be to delete all existing contacts and rewrite all the records to outlook again, which would take a long time to sync on the devices.

If its of any use, I'm using office 2013 on windows 8.1
 
Just replying as I've figured out what I was doing wrong, I'm new to automation with outlook and the folders thing really stumped me

Probably obvious to most here, but for me using the following line to switch the folder finally worked :)

in the code

I had to change
Code:
GetDefaultFolder(olFolderContacts)
to
Code:
 Folders.Item("[COLOR=#0066cc][COLOR=black]<[/COLOR]Account name in outlook[/COLOR][COLOR=black]>").Folders("Contacts")[/COLOR]
just posting incase it does help someone else
 

Users who are viewing this thread

Back
Top Bottom