Stack Overflow
Stack Overflow

Questions tagged [rdcomclient]

This package provides dynamic (i.e. non-compiled) access to COM objects from within R. It allows R to act as a COM client and invoke methods and access properties in any COM object that implements the IDispatch interface.

This package provides dynamic (i.e. non-compiled) access to COM objects from within R. It allows R to act as a COM client and invoke methods and access properties in any COM object that implements the IDispatch interface. This allows us to access and control applications such as Excel, Word, Power Point, Web browsers, etc.

Information from: http://www.omegahat.org/RDCOMClient/

112 questions
15
votes
0 answers

Memory Leak When Opening Data Frame With RDCOMClient

I am experimenting with using the RDCOMClient package to open a dataframe on the fly into Excel. I have functional code which will open a dataframe into Excel, however the issue I am running into is that the memory resources from loading the data…
Matt Jewett
  • 2,857
  • 1
  • 10
  • 19
11
votes
2 answers

How to retrieve Outlook inbox emails using R RDCOMClient?

library(RDCOMClient) ## create outlook object OutApp <- COMCreate("Outlook.Application") I want to retrieve today's email from an Outlook folder named 'AUX'. Parse through the email's title and if it meets certain conditions, I want to parse the…
Afiq Johari
  • 926
  • 1
  • 8
  • 18
10
votes
2 answers

Download attachment from an outlook email using R

I receive an email every Sunday with an attachment (a zipped folder). The subject of the email never changes. I want to find the latest email with the specified subject line and download the attachment. I am new R user and so far I have only found a…
asmi
  • 407
  • 5
  • 13
9
votes
0 answers

Getting " 80020009 Error in .COM(x, name, ...) :" in R while accessing excel file

I have automated the process of accessing VBA Macros, from R, using Openxlsx and RDCOMClient packages. Below is the code: Function: OpenExcel_5param <- function(directory,filename, MacroName, param1, param2, param3,param4, param5) { # Open a…
Rajat Bhadauria
  • 91
  • 1
  • 2
9
votes
2 answers

Sending R Markdown output as body email via outlook (RDCOMclient)

Just learning R Markdown language and wondering if I can send the output in body email via outlook from R (using RDCOMClient; my office don't use gmail) Thank you
edit_profile
  • 127
  • 1
  • 7
9
votes
0 answers

RDCOMClient: How to use enumeration objects or how to get their correspoding values?

The RDCOMclient package can be used to connect to COM objects on Windows. In the MSDN reference many enumerations exist (e.g. wdColorBlue for blue, see here) which correspond to a value. These can be directly used e.g. in VBA code. How can I work…
Mark Heckmann
  • 9,829
  • 3
  • 48
  • 77
8
votes
7 answers

Sending Email Attachement Through Outlook in R with RDCOMClient

I'm Running a daily analysis that spits out a file I would like sent through my outlook Email. The code I used is featured here, and works wonderfully but the attachment part of it never works... library(RDCOMClient) OutApp <-…
GregK
  • 81
  • 1
  • 5
7
votes
1 answer

RDCOMClient error - No support for InterfaceSupportsErrorInfo

I am running a daily task in R which retrieves an email (which has a csv file attached) from my Outlook, performs some analysis on the csv file and writes a resulting data frame to a local drive in my company. Some mornings I find that the files…
John F
  • 595
  • 5
  • 16
7
votes
1 answer

How to add my Outlook email signature to the COM object using RDCOMClient

I am working RDCOMClient into some of my work flow and thanks to agstudy's answer Here I am able to send emails throuhg r, but I can't figure out how to add my Outlook email signature. I'm new to COM objects, but have done a fair share of searching…
Ben
  • 155
  • 1
  • 10
5
votes
0 answers

Reading a password-protected xlsx-file into R without installing Java (password is known)

currently I am preparing an R-lesson for a customer. We want to read in data from a password protected xlsx file. Thus, I am trying to read this password protected xlsx file into R (unprotecting the file itself is no solution). Unfortunately I…
Chris
  • 431
  • 3
  • 7
5
votes
4 answers

Can't build RDCOMClient using rtools40 and R 4.0

A while back, I created a fork of the RDCOMClient package to keep it working with R 3.6 (https://github.com/dkyleward/RDCOMClient). People are now running into issues again because it won't work with R 4.0. The problem doesn't seem as easy to fix,…
Kyle Ward
  • 799
  • 1
  • 5
  • 15
5
votes
1 answer

Is there a way to find/read the Sender Email Address using R, RDCOMClient

library("tm") library("NLP") library("dplyr") library("readtext") library("readxl") library("foreach") library("devtools") library("RDCOMClient") library("rlist") WDF = vector() OutApp <- COMCreate("Outlook.Application") outlookNameSpace =…
Parth Kalra
  • 125
  • 1
  • 1
  • 10
5
votes
1 answer

Using RDCOMClient how can i use the advancedsearch() function to search within different mailboxes?

The outlook account that I am using has multiple mailboxes set up and although the following answer seems to show how to use the function, I am unable to get this to work as I have multiple mailboxes with the "Inbox" folder. Download attachment from…
JHardy16
  • 51
  • 2
5
votes
0 answers

Sending email in R via Outlook 2016

I've been using RDCOMClient package as described here Sending email in R via outlook. Everything was working fine with Outlook 2010 and Windows 7. The script is not working since I've changed the system to Windows 10 with Outlook 2016. Here is the…
Wolf1
  • 51
  • 2
5
votes
1 answer

Html table output formatting when sending email from Microsoft Outlook using R

I am trying to convert a dataframe into an html table using the htmlTable package and then send an email using Microsoft Outlook as the email client using RDCOMClient package by appending the html table as the body of the email. I am new to HTML…
Code_Sipra
  • 1,211
  • 3
  • 13
  • 32
1
2 3 4 5 6 7 8