Automate Email Drafting and Sending with Microsoft Outlook in n8n

What This Automation Does ⚙️

This workflow creates an email draft in Microsoft Outlook with HTML format.

It downloads an image from the internet and adds it as an attachment to the draft.

Then, it sends this email draft automatically to chosen recipients.

It links the nodes so data flows step-by-step without errors.

This saves time and stops common mistakes like forgetting attachments or wrong recipients.

Tools and Services Used

• Microsoft Outlook: For creating, attaching files, and sending emails.
• HTTP Request node: Downloads files from the web.
• Manual Trigger node: Starts the workflow manually for testing or running.
• n8n platform: Builds and runs the automation workflow.

Input, Process, and Output

Inputs

• Email subject and HTML body content set in the Outlook draft node.
• Attachment file URL entered in the HTTP Request node.
• Recipient email addresses for sending the email.

Processing Steps

• Create a draft email with formatted HTML body.
• Download image file from the specified URL.
• Attach the downloaded file to the draft email by referencing its ID.
• Send the draft email to the listed recipients.

Output

• An email sent from the Outlook account with proper attachments and formatted content.

Beginner step-by-step: How to Use This Workflow in n8n for Production ✏️

Importing the Workflow

1. Inside the n8n editor, click the Download button on this page to get the workflow file.
2. Use the Import from File option in n8n to upload the downloaded workflow.

Configuring Credentials and Settings

1. Go to each Microsoft Outlook node and add your Outlook account with OAuth2 credentials.
2. Check the HTTP Request node and adjust the URL if you want a different attachment.
3. Update recipient emails in the sending node as needed, using commas for multiple addresses.

Testing and Activation

1. Run the workflow manually by clicking Execute to see it work and check for errors.
2. Once confirmed, activate the workflow to run on demand or replace the trigger with a schedule for automation.
3. If using self-host n8n, monitor logs to ensure smooth operation.

Customizations ✏️

• Change the HTML in the first Outlook node to use your own message style.
• Change the HTTP Request URL to get other files, like PDFs or documents.
• Put many emails separated by commas in the recipient field to send to groups.
• Use a Schedule Trigger instead of Manual Trigger to automate the workflow at set times.
• Make the attachment name dynamic by linking it to the downloaded file’s name.

Troubleshooting 🔧

Problem: Email not sending, error: “Invalid recipient address”

Cause: Recipient email format is wrong or missing.

Solution: Check the emails in the sending node, use commas for multiple emails.

Problem: Attachment not added to draft

Cause: Wrong messageId reference or file data not correct.

Solution: Make sure the expression {{$node[“Microsoft Outlook”].json[“id”]}} points right and HTTP Request outputs a file.

Problem: Workflow stops unexpectedly

Cause: Expired or missing OAuth2 token or permissions.

Solution: Reauthorize the Outlook account in n8n with needed permissions.

Pre-Production Checklist ✅

• Check Microsoft Outlook OAuth2 credentials are working well.
• Test if the HTTP Request URL is accessible and returns a file.
• Confirm draft email appears after running the first Microsoft Outlook node.
• See if the attachment is correctly added before sending.
• Send a test email to your own inbox first to verify everything.

Deployment Guide

Turn on the workflow by clicking Activate in n8n.

Run it by manual trigger or swap trigger to schedule for automatic runs.

Watch execution logs in n8n for errors or success messages.

Summary

✓ Saves hours by automating email drafting, attaching and sending.

✓ Stops mistakes like missing attachments or wrong recipients.

→ Sends formatted emails with correct files to designated people.

→ Allows easy customization of content, attachment, and schedule.