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
0
votes
1 answer

RDCOMClient Create + Write Mail to Drafts Folder of Specific Account

I am trying to use RDCOMClient to create a large number of mails with attachments. Creating and sending mails as described, e.g., here is working perfectly. But I would like to first generate the mails in the 'Drafts' folder of a specific account to…
cataclysmic
  • 187
  • 7
0
votes
1 answer

How to edit First Page Number in excel via R RDCOMClient?

I am trying to edit the First Page Number in Page Setup in Excel Via R library(RDCOMClient) xlApp <- COMCreate("Excel.Application") xlApp[["Visible"]] <- TRUE xlBook <- xlApp[["Workbooks"]]$Add() xlSheet <-…
Mohamed
  • 95
  • 7
0
votes
2 answers

Sending email in R version 3.6.0 via outlook by RDCOMClient package

I updated R in version 3.6.0. Then I started to have problem with Library RDCOMClient. Does anyone know how to solve problem with R version 3.6.0 and library RDCOMClient? Or does it exist some alternative way how to send emails in R via…
M.Pe
  • 1
0
votes
1 answer

R: Looping over two variables with RDCOMClient

I have a data frame of names and mails, and I would i like to create a loop where R sends a mail to all of these people but with their respective names using the RDCOMClient library. The data frame is df <- data.frame("Name" = c("Name1", "Name2"),…
Emil Nyboe Blicher
  • 19
  • 4
0
votes
1 answer

Smart way to save a data table on open workbook with RDCOMClient

I have a workbook with two worksheets say simply 1 and 2. Worksheet 1 has a button that when clicked, runs a VBA sub to call an R script. Using the package RDCOMClient, the R script connects to the (still open) workbook, reads some data tables off…
user213070
  • 1
  • 2
0
votes
0 answers

Encountered error when extracting outlook email body with RDCOMClient

I am trying to extract the body of a few outlook emails with their email subject containing the keyword "Permission" using RDCOMClient in R. This is the code that I have written. OutApp <- COMCreate("Outlook.Application") OutlookNameSpace <-…
Wyn Z.
  • 35
  • 4
0
votes
0 answers

RDCOMClient Error - InterfaceSupportsErrorInfo persists after suggested fixes

Using the code below to pull a .csv file from Microsoft Outlook into R for routine data manipulation and keep getting the following error (specifically after running the results lines): 80020009 No support for…
hahannah22
  • 1
  • 3
0
votes
0 answers

RDCOMClient on linux docker

We are trying to run R scripts with the RDCOMClient lib on AWS Dockers, but we are getting some erros. We are installing the package with the following command: devtools::install_github("omegahat/RDCOMClient") And it gives us this…
Renato Bibiano
  • 371
  • 1
  • 2
  • 12
0
votes
1 answer

Create new Excel application using RDCOMClient

I have the following code which uses the existing and open Excel application. How to I force R to open a new Excel application and open the workbook in this new Excel station? xlApp <- COMCreate("Excel.Application") xlWbk <-…
Jeweller89
  • 19
  • 1
  • 5
0
votes
2 answers

RDCOMClient log file

I have been using RDCOMClient for a while now to interact with vendor software. For the most part it has worked fine. Recently, however, I have the need to loop through many operations (several hundred). I am running into problems with the…
fsumathguy
  • 95
  • 6
0
votes
0 answers

Have a Shiny App Populate an Email on the Client's Side

I would like the Shiny app to allow users to prepare an email (which would be knit in html before sending) and then the app would open the user's Outlook with the email all ready, with attachments. I can achieve this on my work computer using the…
pollytatouin
  • 81
  • 1
  • 6
0
votes
1 answer

RDCOMClient + Outlook email search using date in R

I am trying to search emails in the mail using RDCOM client in r. i am not able to search the mails using date as filter. I am getting all the mails present in my inbox when i use the code below library(RDCOMClient) outlook_app <-…
Himakund Mallampalli
  • 25
  • 4
0
votes
3 answers

R Studio email from RDCOMClient

I have R Studio version 3.4.3. I'm having a problem sending emails to min 2 people (in the future to over 100 people). For example: Mail to one person. Here everything is ok. This is code: library(RDCOMClient) OutApp <-…
Madelaine
  • 1
  • 1
  • 1
0
votes
2 answers

Send email to a list - R

I have a database in R with a list of email addresses (several on each row). I would like to be able to send a template email to each row with some varying elements in the text (name, action required). I was thinking to use a function with the…
Lénaïc Couderc
  • 31
  • 3
0
votes
1 answer

Calling a cpp function inside RDCOMClient package

New to R programming so bear with me. I am trying to call a function defined in a cpp file inside the RDCOMClient package called R_convertDCOMObjectToR. I did not write that package - it's available here: https://github.com/omegahat/RDCOMClient I…
BadJerry
  • 154
  • 1
  • 12
1 2 3
…
8
9