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

RDCOMClient + Outlook email

I am trying to send emails from my outlook via an R-Code. It is working well for most part. I am using the RDCOMClient to do what I need. The only issue is the Signature; I tried instructions given in this link: How to add my Outlook email signature…
Santhosh Krishnan R
  • 33
  • 1
  • 5
2
votes
2 answers

Running Excel macros from R through RDCOMClient, error -2147418111

The objective is to add data to an existing excel file with OpenXLSX, then run macros in the same Excel file using RDCOMClient, saving it along the way, from an R script. The Excel macros make changes to the pivot table filters and collapse points…
Ben Jacobson
  • 83
  • 1
  • 9
2
votes
0 answers

How to retrieve Outlook Mail items using R RDCOMClient?

I have been using R's RDCOMClient package to manipulate Excel files and it has been a tremendous help. Now I am venturing on to using Outlook and have learned how to send mail using the thread here However, I want to use R's RDCOMClient to retrieve…
rkingsley
  • 21
  • 2
2
votes
1 answer

How to change Chart Title in Excel via RDCOMClient?

How do I change the title of my chart in Excel via the RDCOMClient package? I can create a chart and obtain its title as follows: # Load package and helper functions - see…
Tony Breyal
  • 5,338
  • 3
  • 29
  • 49
1
vote
1 answer

Replace Text in Word documents using R and RDCOMClient

Using RDCOMClient, we can directly replace values in Excel cells, e.g. range <- sheet$Range('A1') range[['Value']] <- 1.2 In Word, Texts can be retrieved from the Text property of a range object, e.g. word.doc[['Tables']][[1]]$Cell(2,…
mzuba
  • 1,226
  • 1
  • 16
  • 33
1
vote
1 answer

How to extract email ids from a data frame column and send mail automatically using R

I am using the RDCOMClient library to automate outlook mails from R. Now the count of recipients' mail id changes periodically. Is there any way to automatically access the ** Email ID ** column in a data frame, say df, and send mail…
MSM
  • 69
  • 7
1
vote
1 answer

Extract Outlook Contacts using R

I am trying to query Outlook Contacts and extract them all in a csv file using R programming language. I have a example piece of code: ##################################################### library(RDCOMClient) ## init com api OutApp <-…
MNapoli
  • 40
  • 6
1
vote
1 answer

Reply all to an Outlook email via R

I'd like to reply all to an email in Outlook (say, the first object in emails below), but can't reconcile how to create a new mail object and reply all to that first object in emails. require(RDCOMClient) require(tidyverse) OutApp <-…
BSHuniversity
  • 264
  • 1
  • 6
1
vote
1 answer

Installing RDCOMClient in Databricks

I am trying to install RDCOMClient in databricks so I can send emails through Outlook. Below is my code in a cluster: devtools::install_github("omegahat/RDCOMClient") library(RDCOMClient) This is the error I am getting: Any idea why this may be…
nak5120
  • 4,089
  • 4
  • 35
  • 94
1
vote
1 answer

Cannot install SWinTypeLibs, but need to know what functions are in ComCreate(Word.Application)

Please forgive me if this is not perfect but this is my first post. I am currently working on trying to transform a large number of .docx documents into .pdf I have found the RDCOMClient package which has done wonders. However I now need to add alt…
James
  • 11
  • 1
1
vote
1 answer

import and run excel module .bas with RDCOMClient

I'm trying to use RDCOMClient to import a module to an excel workbook. xlApp <- COMCreate("Excel.Application") XlWbk <- xlApp$Workbooks()$Open(paste0(root, "test.xlsx")) xlWbk.VBProject.VBComponents.Import(paste0(root, "macro/Module1.bas")) the…
Frank
  • 952
  • 1
  • 9
  • 23
1
vote
1 answer

How to retrieve emails by date using RDCOMClient

I am trying to retrieve only emails received "today" from particuarly folder in my outlook inbox. How would I be able to do this? The follow code below allows me to extract emails all from a inbox, but I am only interested in emails that were…
Dieu94
  • 371
  • 1
  • 11
1
vote
0 answers

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

I use this exact code (Sending R Markdown output as body email via outlook (RDCOMclient)) and it worked just fine, until I update my version of R to 3.6.1. I also tried the 3.5 version of RDCOMClient as explained here (RDCOMClient for R 3.6) and I…
Johanie Fournier
  • 15
  • 5
1
vote
1 answer

Looping through a dataframes, collecting data, creating new dataframes

I have the below dataframe (in reality it spans a couple hundred rows of the same data). project_number hours team_member project_lead team_member_email RR711-132 4 Isaac Bell Dan Case ib@blank.com RR711-135 …
isaacbell1234
  • 31
  • 4
1
vote
1 answer

Apply own function with three inputs to dataframe

I have this function which sends mail via the library, RDCOMClient. I have used it previously with two inputs both stemming from a dataframe using the map2 function from purrr. Now I have extended the function to include three inputs, and I can't…
Emil Nyboe Blicher
  • 19
  • 4
1 2 3
…
8 9