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
4
votes
3 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
  • 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
  • 525
  • 5
  • 23
4
votes
0 answers

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
  • 148
  • 7
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
  • 3,410
  • 3
  • 23
  • 62
4
votes
1 answer

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,112
  • 10
  • 22
3
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
  • 53
  • 2
3
votes
3 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
  • 41
  • 2
3
votes
0 answers

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
  • 3,410
  • 3
  • 23
  • 62
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
  • 3
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
  • 7
3
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,211
  • 3
  • 13
  • 32
3
votes
1 answer

Is it possible to send visualizations through RDCOM?

I am relatively new to R programming and have undertaken a little side project to introduce myself to the world of R. What I would like to do is help one of my colleagues automate a manual email process that he does each week. The email consists of…
ShuN
  • 45
  • 5
3
votes
2 answers

Emailing multiple attachments using RDCOMClient and Outlook

I have an R script that I want to automatically send an email using Microsoft Outlook after it has finished completing. I'm using the "RDCOMClient" package and I want to add multiple attachments to the email. Here's the code that I'm trying to…
David
  • 812
  • 3
  • 12
  • 30
3
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,068
  • 3
  • 25
  • 48
2
votes
2 answers

Full list of methods for COM objects

I would like to know which functions I can use with RDCOMClient objects. For example, to create an email we can use OutApp <- COMCreate("Outlook.Application") # create an email outMail = OutApp$CreateItem(0) Along with outMail[["subject"]],…
CatalystRPA
  • 1,782
  • 1
  • 9
  • 18
1
2
3 4 5 6 7 8