Extract Outlook Contacts using R

Asked Apr 29 '21 at 12:15

Active Apr 29 '21 at 13:57

Viewed 33 times

I am trying to query Outlook Contacts and extract them all in a csv file using R programming language. I have a example piece of code:

#####################################################
library(RDCOMClient)
## init com api
OutApp <- COMCreate("Outlook.Application")
olFolderContacts <- 10

# get the namespace
ns <- OutApp$GetNamespace("MAPI")
# get the contact folder
folderContacts = ns$GetDefaultFolder(olFolderContacts)
# get the contact list
folderItems = folderContacts$Items()
i = 0
# get the first contact
itemObj = folderItems$Item(i+1)
#####################################################
# That's here that it fails
#####################################################
ContactName <- itemObj$GetElement()$Name()
#####################################################

The idea is that the folder contains items which are of different type. How to query the Object COM interface to get the object type or Class and how to invoke the methods related to it?

Thanks,

Maurizio.

edited Apr 29 '21 at 13:57

CatalystRPA

1,782
1
9
18

asked Apr 29 '21 at 12:15

MNapoli

1

welcome to SO ;) – CatalystRPA Apr 29 '21 at 12:20
please describe the error you get? – CatalystRPA Apr 30 '21 at 08:17
I managed to fix it... – MNapoli May 04 '21 at 11:20
Here is the code: – MNapoli May 04 '21 at 11:20
`code` library(RDCOMClient) ## init com OutApp – MNapoli May 04 '21 at 11:20
it's better if you answer your question: https://stackoverflow.com/help/self-answer#:~:text=If%20you%20have%20more%20than,own%20question%20at%20any%20time. – CatalystRPA May 04 '21 at 12:19
also code in comments can be done with ` – CatalystRPA May 04 '21 at 12:19

Extract Outlook Contacts using R

0 Answers0