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
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
  • 65
  • 6
3
votes
1 answer

How to show an excel worksheet in outlook body by R

I can attach an excel file into outlook by RDCOMClinet package. but how can I show the excel worksheet content in the mail body by R? Assume there's a table and a graph are contained in a worksheet. library(RDCOMClient) ## init com api OutApp <-…
Anson Leung
  • 31
  • 1
  • 2
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…
JohnN
  • 968
  • 4
  • 13
  • 35
2
votes
0 answers

Data formatting issues; Is my function the problem?

every day I get an email listing sales in a shop for the previous day. My email looks like this: Date of report:,15-JAN-2022 Time report produced:,16-JAN-2022 00:25 Service:…
alec22
  • 735
  • 2
  • 12
2
votes
3 answers

Strange InterfaceSupportsErrorInfo error - checkErrorInfo -2147352567 Error: Exception occurred

I'm currently building a bit of code to search my emails for a particular subject and then search the body of the emails for some particular terms, then take comma separated data out of it. However I have now encountered an issue which I've never…
alec22
  • 735
  • 2
  • 12
2
votes
3 answers

In R: Search all emails by subject line, pull comma-separate values from body, then save values in a dataframe

Each day, I get an email with the quantities of fruit sold on a particular day. The structure of the email is as below: Date of report:,04-JAN-2022 Time report produced:,5-JAN-2022 02:04 Apples,6 Pears,1 Lemons,4 Oranges,2 Grapes,7 Grapefruit,2 I'm…
alec22
  • 735
  • 2
  • 12
2
votes
1 answer

How to place attachments inside a zip file using RDCOMClient?

Context: I currently send 10 separate HTML files markdown files to my audience, however, in the email it sends as different attachments as such in the image below: How can I package all these attachments in a single zip file instead individual…
Jaskeil
  • 1,044
  • 12
  • 33
2
votes
1 answer

Outlook$CreateItem(0) crashes R (using package RDCOMClient)

I solved this issue but documenting here in case anyone experiences difficulty using RDCOMClient to send Outlook emails via R. Using fresh install of Windows 10 Pro for Workstations running as a VirtualBox VM, R version 4.1.1, Rstudio 2021.09.0…
cmcgraw
  • 61
  • 4
2
votes
1 answer

using RDCOMClient to pull emails from a folder

I have a script to pull emails from a certain folder, however the number of emails being returned in R does not match how many emails are in the folder. I think Outlook or R is truncating the folder at a certain max size of items. Is there any way…
Rafael
  • 3,096
  • 1
  • 23
  • 61
2
votes
0 answers

Cannot get Russian Subject from Outlook using RDCOMClient

I am using Outlook under Windows 10 as my email client and am trying to use the RDCOMClient library to process some emails. Some of the emails are in Russian and I am having trouble getting the Russian part out in a usable format. Right now, I am…
G5W
  • 36,531
  • 10
  • 47
  • 80
2
votes
1 answer

Using RDCOMClient to search Outlook inbox

I'm attempting to use RDCOMClient to search my Outlook inbox for specific subjects in emails and then grab the attachment. I have this working on a single email, but as the subject contains a date element, I need the search to be a like clause, but…
Ed Cunningham
  • 179
  • 1
  • 3
  • 17
2
votes
2 answers

RDCOMClient + Outlook email + Attachment filename

I am trying to get the name of a attachment in the mail using RDCOM client in r. i am able to get the name of subject and also the text in the body But i am not able to figure out how to get the name of attachment OutApp <-…
Himakund Mallampalli
  • 25
  • 4
2
votes
1 answer

RDCOMClient - Set Vertical Range Values

I am trying to write values into a vertical Range using the RDCOMClient library. Since the RDCOMClient allows you to write code very similar to VBA, I've been looking for ways to do this in VBA and then translate to R. The base R code to create the…
Daniel
  • 639
  • 8
  • 24
2
votes
1 answer

Edit excel property using RDCOMClient

I am unable to find any documentation for RDComClient package. I am unable to find the suitable parameter to change the background fill for a cell. library(RDCOMClient) xlApp <- COMCreate("Excel.Application") book =…
Koyeli
  • 67
  • 1
  • 9
2
votes
1 answer

outMail[["From"]] In R

I have a shared email account for my group at work. I've used StackOverflow to very helpfully automate the process of sending an email with multiple attachments from my personal email but I'd like to change the address to be from the shared email…
Jay
  • 61
  • 2
1 2
3
…
8 9