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/

127 questions
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

How to use RDCOMClient to send Outlook email from a secondary account - translate existing VBA code?

I am trying to send an email from a secondary email address using RDCOMClient. I took the advice from How to retrieve Outlook inbox emails using R RDCOMClient? and tried writing it in VBA and translating, but could not get the right commands. …
RustlessBroom
  • 158
  • 7
5
votes
2 answers

RDCOMClient suggested in package

I had my R-package using RDCOMClient via DESCRIPTION file: Suggests: RDCOMClient and the following (perfectly working) code: GetNewWrd <- function() { stopifnot(require(RDCOMClient)) # Starts the Word application with wrd as handle wrd <-…
Andri Signorell
  • 1,279
  • 12
  • 23
4
votes
2 answers

RDCOMClient package suddenly gives me: No support for InterfaceSupportsErrorInfo

I've been using the RDCOMClient packge in R for over a year now without a problem. Now suddenly it's giving me an error: 80070057 No support for InterfaceSupportsErrorInfo checkErrorInfo -2147024809 Error: The parameter is…
Viðar Ingason
  • 265
  • 3
  • 11
4
votes
0 answers

Disable Outlook Warning Message with RDCOMclient in R

I am using R to build an automated process to run a SQL query, put the result in an Excel file, and then email the file via Outlook to a customer. I am using RDCOMClient with R4.0. Every time I run the script a warning message in Outlook pops up and…
Sammy Saber
  • 63
  • 2
4
votes
5 answers

RDCOMClient installation trouble on R-3.6

I cannot install RDCOMClient, using R-3.6 Some background: RDCOMClient works in my R-3.51 instance, and I need to use 3.6, and I need to use RDCOMClient to interact with my desktop's Outlook. mailR and sendmailR are not currently an option. Thing's…
jaramana
  • 67
  • 1
  • 8
4
votes
1 answer

RDCOMClient (Outlook) - ggplot

I'm using the RDCOMClient library to create an Outlook email. I want to send a ggplot as an image inside the email body (inline), not as an attachment. The only way I see this as possible is adding the plot as an image inside the HTMLBody property.…
Daniel
  • 639
  • 8
  • 24
4
votes
1 answer

Extracting Zip+CSV file from attachment w/ Image in Body of Email

I receive daily emails where there is an attachment containing 1 zip file containing 1 csv file. In the body of my email, there is an image that is being recognized as another attachment I am pretty sure. The below script works when there is only…
nak5120
  • 4,089
  • 4
  • 35
  • 94
4
votes
1 answer

Send email from outlook by including dataframe as table in R

I have a dataframe as shown below. I am then converting the dataframe into an html table. # Use RDCOMClient to send email from outlook library(RDCOMClient) # Use xtable to convert dataframe into html table library(xtable) # Create dataframe df <-…
Code_Sipra
  • 1,571
  • 4
  • 19
  • 38
4
votes
1 answer

How to interpret the VBA "with" function structure into R code via RDCOMClient?

Context: I am using R to do some data manipulation which I then export to Excel and create a barchart with. Problem: Thus far it is relaitively easy to record an Excel VBA macro and then translate it into R code via the RDCOMClient package. However…
Tony Breyal
  • 5,338
  • 3
  • 29
  • 49
3
votes
1 answer

RDCOMClient with COMCreate("Outlook.Application") crashing R

I'm using the package RDCOMClient with R version 4.0.2. It was downloaded using: devtools::install_github("omegahat/RDCOMClient") I'd like to use the package for reading and writing email. I've started this way: library(RDCOMClient) folderName <-…
Richard Bryant
  • 31
  • 2
3
votes
2 answers

DescTools::XLGetRange() fails with sel$Cells() Error: attempt to apply non-function

I am running R version 3.5.0 I have installed the packages: install.packages("DescTools") install.packages("RDCOMClient", repos = "http://www.omegahat.net/R") I have run Excel and selected a range of values. Then I run this code in…
Herman Tan
  • 49
  • 2
3
votes
1 answer

Download Link from email and call that file into R

I have a daily email that is sent to me and within that email, there is a download link. When you click on the download link, there is a csv file that gets downloaded with a different file name every time. On top of this, the download link name…
nak5120
  • 4,089
  • 4
  • 35
  • 94
3
votes
2 answers

Sending Outlook Emails via R workaround on OSX

I've looked throughout the site but have not been able to find an answer. I need to use R to send emails via my works outlook email. It has to be from Outlook, not anywhere else. Problem is, the computer I'm using is OSX so RDCOMClient won't work.…
Karl Marxdown
  • 31
  • 4
3
votes
1 answer

Sending email attachment in R via Outlook

I need to send an email attachment in R via Microsoft Outlook. All of the code on this page works except for the line of code that sends an email attachment. Sending email in R via outlook The line of code that does NOT work for me…
FinProg
  • 155
  • 1
  • 7
1
2
3
…
8 9