How to retrieve Outlook inbox emails using R RDCOMClient?

by

Here is some sample code I got to work by trial and error:

library(RDCOMClient)

folderName = "AUX"

## create outlook object
OutApp <- COMCreate("Outlook.Application")
outlookNameSpace = OutApp$GetNameSpace("MAPI")

folder <- outlookNameSpace$Folders(1)$Folders(folderName)
# Check that we got the right folder
folder$Name(1)

emails <- folder$Items

# Just doing first 10, get total number with emails()$Count()
for (i in 1:10)
{
  subject <- emails(i)$Subject(1)
  # Replace "#78" with the text you are looking for in Email Subject line
  if (grepl("#78", subject)[1]){
    print(emails(i)$Body())
    break
  } 
}

Sorry, but I don’t know why some of these COM object require parameters (like Subject(1)), but others don’t (like Body()). This worked for me on Outlook 2013, but it should also work on all versions of Outlook from 2007 on.

To get more info on the Outlook Object model I would suggest you either get Ken Slovak’s Outlook 2007 book (still relevent for later versions of Outlook), or else check out my personal website, http://www.gregthatcher.com (check out the “Scripts” section — I have been compiling these for many years.)

More Related Contents:

  1. How to send an email with attachment from R in windows
  2. Sending email in R via outlook [closed]
  3. R: replace the whole part of a number but keep the decimal part unchanged
  4. What is the difference between require() and library()?
  5. Why is the parallel package slower than just using apply?
  6. Scale a series between two points
  7. How to replace NA values in a table for selected columns
  8. Count the number of all words in a string
  9. R: gsub, pattern = vector and replacement = vector
  10. How do I calculate the co-occurrence in the table? [duplicate]
  11. Rcpp pass by reference vs. by value
  12. Replace / translate characters in a string
  13. using Unicode ‘dingbat-like’ glyphs in R graphics, across devices & platforms, especially PDF
  14. How to rename a single column in a data.frame?
  15. Count number of rows by group using dplyr
  16. Adding space between bars in ggplot2
  17. Dynamically build call for lookup multiple columns
  18. Align plot areas in ggplot
  19. Split dataframe by levels of a factor and name dataframes by those levels
  20. Use rle to group by runs when using dplyr
  21. What is the algorithm behind R core’s `split` function?
  22. Installing package – cannot open file – permission denied
  23. Add column with order counts
  24. Why I get this error writing data to a file
  25. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  26. How to cross-paste all combinations of two vectors (each-to-each)?
  27. Efficient calculation of matrix cumulative standard deviation in r
  28. how do you order Months in ggplot
  29. Multiply columns in a data frame by a vector
  30. R – What algorithm does geom_density() use and how to extract points/equation of curves?

Leave a Comment