How to Send Microsoft Outlook Emails with New Microsoft Excel Rows Using Pabbly Connect

Learn how to automate sending emails from Microsoft Outlook using new rows in Microsoft Excel with Pabbly Connect. Step-by-step tutorial included. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Microsoft Outlook Emails

To send Microsoft Outlook emails using new Microsoft Excel rows, you first need to access Pabbly Connect. This automation platform allows seamless integration between Microsoft Excel and Outlook.

Begin by signing up for a free account on Pabbly Connect. Once logged in, navigate to the dashboard. Click on the ‘Create Workflow’ button and name your workflow, such as ‘Excel to Outlook Emails’. This name helps you identify the workflow later.

2. Configuring Microsoft Excel as the Trigger App

In this step, you will configure Microsoft Excel as the trigger application in Pabbly Connect. Click on the trigger field, and from the dropdown, select Microsoft Excel.

• Choose the trigger event as ‘New Row in Worksheet’.
• Click the ‘Connect’ button and establish a new connection with Microsoft Excel.
• Select your workbook and worksheet where the email data is stored.

After saving the configuration, Pabbly Connect will fetch the most recent row added in your Excel sheet, capturing the necessary details such as name, email, and email content.

3. Setting Up Microsoft Outlook as the Action App

Next, you will set up Microsoft Outlook as the action app within Pabbly Connect. Search for ‘Microsoft Office 365’ in the action step.

• Select the action event as ‘Send Email’.
• Click the ‘Connect’ button and authorize your Microsoft Office 365 account.
• Fill in the email subject, content type, and body using the data fetched from Excel.

Mapping the email fields is crucial, as it ensures that the correct data is sent to the right recipients. This setup allows Pabbly Connect to automatically send emails to the specified addresses whenever a new row is added.

4. Testing the Integration with Pabbly Connect

Now that both applications are configured, it’s time to test the integration. Click on the ‘Save and Send Test Request’ button in Pabbly Connect to initiate a test email.

Check your Microsoft Outlook inbox to confirm that the test email was successfully sent. You should see the email with the subject and content you specified. This step validates that your workflow is correctly set up and functional.

5. Final Steps and Automation with Pabbly Connect

Once the test is successful, your automation is complete! With Pabbly Connect, you only need to set up this workflow once, and it will run in the background.

Every time you add a new row to your Excel sheet, an email will automatically be sent through Microsoft Outlook based on the details provided. This automation saves you time and effort in sending emails manually.

Conclusion

In this tutorial, we have demonstrated how to use Pabbly Connect to automate sending Microsoft Outlook emails using new rows in Microsoft Excel. This powerful integration streamlines your email communication process and enhances productivity.