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

Attaching one spreadsheet per email from R using RDCOMClient and for loop?

I asked this question a couple of days ago here on this link. The solution partially worked but the issue is that the logic sent out a lot of emails with all the attachments instead of one attachment per email. Below is my code/logic. Ideadlly, I…
Jaskeil
  • 1,044
  • 12
  • 33
0
votes
1 answer

Sending an Email from R Using For Loop? Using RDCOMClient

I currently have 5 spreadsheets that I need to email out separately into 5 emails. This is the logic I currently have for the email: #Script to send out attachments <- c('C:/Users/santi/Documents/Cost Changes xlsx/spreadsheet.xlsx') #spreadsheet…
Jaskeil
  • 1,044
  • 12
  • 33
0
votes
3 answers

How to attach date in subject of mail using RDCOMClient

I need to attach previous day date in subject of mail using RDCOMClient, tried below code but no luck. d1=Sys.Date()-1 OutApp <- COMCreate("Outlook.Application") outMail = OutApp$CreateItem(0) outMail[["To"]] =…
MSM
  • 69
  • 7
0
votes
1 answer

R RDCOMClient find and replace in Word Doc

I'm trying to automate a process that replaces some values from a Word report template. I want to find a replace certain values and below is some code that I've tried but is not working library(RDCOMClient) wordApp <-…
user3357059
  • 1,122
  • 1
  • 15
  • 30
0
votes
2 answers

Sending emails in R without outlook app in the system

I'm able to send emails using the following code. OutlookForSend = RDCOMClient::COMCreate("Outlook.Application") emailToSend = OutlookForSend$CreateItem(0) emailToSend[["subject"]] = "Subject" emailToSend[["HTMLBody"]] =…
nsivakr
  • 1,565
  • 2
  • 25
  • 46
0
votes
1 answer

R script RDCOMClient can't open xlsx file

I am trying important data that I've organized in R into an existing table of an existing workbook (xlsx file) I have the following code after the data curation is complete: file <- "U:/Reporting/Template-Business_Report.xlsx" xlApp <-…
morg
  • 381
  • 2
  • 17
0
votes
1 answer

RDCOMClient remove auto filter

I have opened a workbook with RDCOMClient and would like to remove the auto filter on a certain sheet: xlApp <- COMCreate("Excel.Application") xlApp[['Visible']] <- TRUE xlWbk <- xlApp$Workbooks()$Open('file.xlsx') ## sheet with data filters sheet…
Rafael
  • 3,096
  • 1
  • 23
  • 61
0
votes
2 answers

How to send emails with delayed delivery in Outlook from R?

Using the RDCOMClient package in R, I am sending a series of automated emails from R. The emails need to be sent at a specific date and time, but I cannot figure out what elements in the outMail object to manipulate to send emails with delayed…
Tony Beans
  • 175
  • 1
  • 11
0
votes
1 answer

How to obtain the time component of emails received in outlook with R?

I am working on a project where I am required to record and track the received date and time of emails. This is a snippet of the code that I have. library(RDCOMClient) OutApp <- COMCreate("Outlook.Application") OutlookNameSpace <-…
Wyn Z.
  • 35
  • 4
0
votes
0 answers

RDCOMClient trouble - program to connect to Outlook stopped working

I have a program that searches some subfolders of my Inbox and downloads an attachment from daily emails, which is then used for analysis in R Studio. This program was working fine until this morning (it runs daily), and I did not make changes…
LauraDR
  • 86
  • 9
0
votes
3 answers

RDCOMClient read email from a non-Outlook file path

I have a number of emails saved outside my Outlook directory, eg. at some file path "C:\\Users\\foo\\bar.msg". I would like to read these emails into R using library(RDCOMClient); following this question I have been able to read emails into R from…
owen88
  • 454
  • 3
  • 12
0
votes
1 answer

Outlook attachment saving script not working from Windows Command Prompt (works perfectly from RStudio)

Script Objective Save attachment files (.xlsx) from two emails to a network share. Issue R Script below works perfectly well in RStudio but fails when run from Windows command prompt. Error Message < checkErrorInfo> 80020009 No support for…
p2c4
  • 34
  • 2
0
votes
1 answer

Looping through a DataFrame and Sending Email Using RDCOMClient

I have tried this code several different ways and keep getting the same error. I don't believe the code is the issue, I'm wondering if there is a functionality of RDCOMClient I am missing. The functionality works, as I have sent many emails through…
isaacbell1234
  • 31
  • 4
0
votes
1 answer

Sending Email through RDCOM client in rstudio 3.5.1 Error: Exception occurred

I have been successfully sending mails through rstudio using RDCOM till today. my rstudio version is 3.5.1 and i used this link to install RDCOM my code is as follow install.packages("RDCOMClient", repos = "http://www.omegahat.net/R") OutApp <-…
Ayesha Saeed
  • 11
  • 4
0
votes
1 answer

RDCOMClient: Download zip attachment from multiple Outlook emails

I've went through the more or less similar questions here on StackOverflow. The closest that answers my question is this one Downloading attachment from Outlook into R In Outlook, I've a custom folder named '47MY Daily Report', which contains daily…
Afiq Johari
  • 1,372
  • 1
  • 15
  • 28
1 2 3
…
8 9