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
1
vote
1 answer

Use RDCOMClient to paste graph into Powerpoint

I have saved a graph to my cliboard using the code x = c(1:5) y = c(1:5) windows(504, 360) #opens a separate window with the size you want plot.new() plot(x,y, bg = "transparent")#my graph has more information but this would…
W Anderson
  • 53
  • 1
  • 5
1
vote
1 answer

Overwrite An Excel File through RDCOMClient Package in R

I am trying to manipulate an Excel file (.xls) in R through RDCOMClient Package. I created an Excel object in R, opened a workbook saved as .xls file format, and tried to convert the file format into .xlsx without pop-up dialog box when there is an…
Nelson Chang
  • 11
  • 2
1
vote
1 answer

R code not sending email via task scheduler but otherwise runs fine

I have a R code which after doing a bunch of steps sends out an email in the end. When I run this on RStudio, the entire code runs fine and sends out the email. However, when I run this via Windows Task Scheduler, the code still runs fine (and does…
Ankur
  • 35
  • 6
0
votes
1 answer

How can I insert an OFT template on an Outlook message using RDComClient?

I wanto to embed or insert a premade oft template on message but I dont knon how can I do it. Im able to embed images, but I need to insert complex html compatible with outlook I have this parte done I can embed image but no html Open…
Cesar Amezcua
  • 1
  • 1
0
votes
0 answers

Change page layout when adding table in word using RDCOMClient

How to change page layout when adding table in word using RDCOMClient Does anyone know how to change the page layout in Word using RDCOMClient, just in the page where certain table is added to the document? My problem is to detect the page where the…
skull_caveat
  • 3
  • 1
0
votes
0 answers

How to make R binary *.zip windows 10 file from *.tar.gz file?

I want to make (if possible) zip file from tar.gz file that is for RDCOMClient R package. I installed that package using this code: devtools::install_github("omegahat/RDCOMClient") So I have got it installed but for the future use I want to save…
Andrzej Andrzej
  • 23
  • 3
0
votes
0 answers

RDCOM client does not work for Outlook 2019?

after installing the new version of Outlook this piece of code produce an error: outlook_app <- COMCreate("Outlook.Application") search <- outlook_app$AdvancedSearch("Inbox","urn:schemas:httpmail:subject = string_to_search"). error: …
Maurizio Lospinoso
  • 1
  • 2
0
votes
0 answers

RDCOMClient in R. How can I sort the Outlook Inbox folder by received date and then run a for loop to detect an email based on the email Subject

I am using the RDCOMClient package in R. I am trying to run a for loop on the Outlook Inbox folder in order to select the last email received by a sender. The goal is to automatically upload an Excel sheet sent as an attachment in this email (which…
Vin
  • 11
  • 1
0
votes
1 answer

R: PDF as attachment in email automation

Need to ask a basic question. I would like to send automated emails with PDF in attachment with R Studio. However, when I run the the outMail line for the attachment I get the following error: 80020009 No support for…
Akibaida
  • 37
  • 6
0
votes
1 answer

Error Adding pictures to Powerpoint slide using RDCOMClient

I am trying to add a picture to a powerpoint slide, in R using RDCOMClient and running into an error: updatePicture <- function(Slide, ShapeName, ImageFileName) { shape <- getShapeByName(Slide, ShapeName) if (shape$Type() == 13 ||…
mrAnalyzers
  • 11
  • 2
0
votes
1 answer

Rstudio - RDCOMCLIENT writing a dataframe to excel generates special characters

While writing some dataframe to excel, via asCOMArray, most of the data is fine. But due to encoding problem, some characters like " - " gets converted to : " †" ; "é" gets changed to : "é" Here lies the code example : xlApp <-…
sayan chakraborty
  • 21
  • 2
0
votes
1 answer

RDCOM Client Error: Unable to send Emails

I am currently trying to send 5 individual emails and spreadsheets through R using the RDCOMClient library. Here are the spreadsheets I am attempting to send in a vector [1] "C:/Users/sxc3gfl/Documents/data-science-team-master/INTERLINE…
Jaskeil
  • 1,044
  • 12
  • 33
0
votes
2 answers

How to retrieve the body of an Outlook email in my inbox using R?

I regularly use the R package RDCOMClient to send emails straight from R, but is there a way to use it to import the body of emails in my inbox into R? Ive seen some answers on here like from here... How to retrieve Outlook inbox emails using R…
Jacob Nordstrom
  • 149
  • 8
0
votes
1 answer

How to avoid multiple entries while executing FOR loop in R

I have a couple of mail-ids in a column and need to send mail automatically through the RDComclient function. The below code is successfully executed but it sends multiple emails to the same sender n times (instead of single mail to every mail-ids).…
MSM
  • 69
  • 7
0
votes
1 answer

How to loop though a dataframe of mail-ids and send mail using RDCOMClient

I need to send mail to all email ids in a column of the data frame. The column values are dynamically changing. I have used FOR loop for this but end up receiving the below warning and it sends mail only to 1st mail id in the…
MSM
  • 69
  • 7
1 2 3
…
8 9