Unanswered

Excel Email Query

(0) Share

Report

Posted on by KatG

Hey folks

I am working on a Power Automate which is using a very simple flow that basically creates an email from a table in Outlook - Send Emails from Excel with Power Automate - YouTube (this is the flow i am using).

However, is there a way to have Outlook open the individual emails BEFORE sending them? At times we may need to slightly tinker with the email before it is sent, including adding attachments that can have complex/non-standard names and including multiple invoice reminders in one email.

The flow in that youtube is basically perfect for what we are wanting to do. Only thing missing is not wanting it to automatically send the email. We just want to have an easier way to generate batch emails.

I am new to Power Automate so any suggestions are welcome!

Thank you

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

David_MA 13,504 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I really don't understand what you mean by opening the e-mail in Outlook before sending it. If you don't send it, how would it get to Outlook? And if you are asking if somehow Power Automate can open the e-mail in Outlook, what would be the purpose?

If you want someone to review the e-mails before they are sent, you could send them to that person instead and include instructions for the review along with the e-mail address of who it should be forwarded to after it has been reviewed. I have several processes where we send this type of e-mail for our customer service department. The customer service rep's e-mail address is included in the data and they are sent the e-mail. They review it and then forward it to the customer after it has been reviewed and modified if needed.

Another option, which may be possible, but I have not tried, would be to use a compose action to format your e-mail in HTML. You can then update the row in Excel with the output. Then you can notify someone to review the spreadsheet and add a column named Send where they could flag Yes or No. Then the next time your flow runs you can process anything tagged as yes and update Send to Sent for the ones processed.

Was this reply helpful? Yes No
jamiekaler123 8 on at

Like (0)

Report
Copy link

Link copied!

The question is very tricky. Difficult figure out the exact requirement.

Was this reply helpful? Yes No