在R语言中通过Outlook发送邮件附件遇问题求助

安全阿岳

2026-5-20

Hey there! Let's figure out why your Outlook email attachments aren't working in R—since the rest of your code runs fine, the issue is almost certainly tied to how you're handling the attachment path or the specific syntax for adding it. Here are some practical fixes and checks to try out:

1. Verify your file path is correct

Use an absolute file path instead of a relative one. Outlook might not resolve relative paths (like "./report.pdf") properly from R's working directory. For example:
```
# Good: absolute path
attachment_path <- "C:/Users/YourUsername/Documents/your_file.pdf"
# Bad: relative path (may fail)
attachment_path <- "your_file.pdf"
```
Confirm the file actually exists with file.exists(attachment_path) in R. If this returns FALSE, your path is wrong—double-check typos, folder names, and that the file isn't moved.
Avoid spaces or special characters in the path if possible. If you can't, make sure the path is wrapped in quotes (R usually handles this, but Outlook can be finicky).

2. Use the correct syntax for your R package

Most folks use RDCOMClient for Outlook integration in R—here's the proper way to add attachments with it:

library(RDCOMClient)

# Initialize Outlook connection
outlook <- COMCreate("Outlook.Application")
# Create a new email
email <- outlook$CreateItem(0)

# Set email details (your working code here)
email[["To"]] <- "recipient@example.com"
email[["Subject"]] <- "Test Email with Attachment"
email[["Body"]] <- "Hi, here's your requested file!"

# Critical line: add the attachment
email[["Attachments"]]$Add(attachment_path)

# Send the email
email$Send()

If you're using a different package like sendmailR, the attachment syntax is very different—you need to read the file as binary data:

library(sendmailR)

# Prepare attachment as a binary object
attachment <- list(
  name = "your_file.pdf",
  type = "application/pdf",
  content = readBin(attachment_path, "raw", file.info(attachment_path)$size)
)

# Send email with attachment
sendmail(
  from = "your.email@example.com",
  to = "recipient@example.com",
  subject = "Test with Attachment",
  msg = list("Body text here", attachment),
  control = list(smtpServer = "smtp.office365.com", port = 587, username = "your.email@example.com", password = "your_password")
)

3. Check Outlook settings and permissions

Make sure Outlook is running in the background when you run your R script. Some versions block COM calls (used by RDCOMClient) if Outlook is closed.
Adjust Outlook's programmatic access settings: Go to File > Options > Trust Center > Trust Center Settings > Programmatic Access. Select "Never warn me about suspicious activity" (or a less permissive option if your security policies allow) to stop Outlook from blocking R's access.
If you're on a work machine, your IT team might have restrictions on automated email sending—check with them if other fixes don't work.

4. Debug the attachment step

Try adding just one attachment at a time to rule out issues with a specific file (like corruption or excessive size).

Print the attachment details after adding it to confirm it was recognized:

added_attachment <- email[["Attachments"]]$Add(attachment_path)
cat("Added attachment:", added_attachment[["FileName"]], "\n")

If this prints the correct filename, the attachment was added successfully—any issue would be with sending (but since your core code works, this is unlikely).

Hope one of these solutions gets your attachments working smoothly! If you can share a snippet of your actual attachment code, I can help narrow it down even more.

内容的提问来源于stack exchange，提问作者FinProg