Automate Email Alerts for Delayed Orders
Budget: $2 – $8 USD
I'm looking to automate part of my daily routine using Power Automate. I have an Excel file saved in OneDrive for Business that contains a list of customer orders, including information on whether each order will be dispatched on time or delayed. I need to filter these delayed orders, group them by country, and send an email to customer service for each country with all the delayed orders.
Key Requirements:
- Filter delayed orders from the Excel file and group them by country.
- Send one email per country containing all delayed orders for that country.
- Format the email content as a table, sorted by order number.
- Include a two-line space between different order numbers, with each order having a table header.
- The email should include product details and the quantity available at the requested dispatch date.
- Use Outlook to send the emails.
- The email sending process should be triggered manually.
Ideal Skills and Experience:
- Proficiency in Microsoft Power Automate for workflow automation.
- Experience with Excel and OneDrive for Business integration.
- Strong skills in formatting and automating emails through Outlook.
- Attention to detail to ensure accurate data filtering and presentation.
- Ability to create user-friendly and visually organized email content.
I look forward to working with a freelancer who can streamline this process and ensure timely communication with our customer service team.
Key Requirements:
- Filter delayed orders from the Excel file and group them by country.
- Send one email per country containing all delayed orders for that country.
- Format the email content as a table, sorted by order number.
- Include a two-line space between different order numbers, with each order having a table header.
- The email should include product details and the quantity available at the requested dispatch date.
- Use Outlook to send the emails.
- The email sending process should be triggered manually.
Ideal Skills and Experience:
- Proficiency in Microsoft Power Automate for workflow automation.
- Experience with Excel and OneDrive for Business integration.
- Strong skills in formatting and automating emails through Outlook.
- Attention to detail to ensure accurate data filtering and presentation.
- Ability to create user-friendly and visually organized email content.
I look forward to working with a freelancer who can streamline this process and ensure timely communication with our customer service team.
Related categories:
PHP
Data Entry
Excel
Software Architecture
Microsoft Office
Automation
Power Automate
Microsoft 365