Automate Follow-Up Emails in Outlook

Create an Excel file with two tables. The Prospects table has columns for name, email, status (starts as "ready"), send date, tracking details, and follow-up messages (FU1, FU2, FU3, and so on). The FU Intervals table has columns for follow-up number, wait type ("days" or "weekday"), and wait value (a number like "2" or a day name like "Thursday"). Fill the Prospects table with the people you want to follow up with and write the follow-up messages in the FU columns. Set the intervals in the FU Intervals table.

Send your first email to the prospect from Outlook. After sending, right-click the sent email, choose Categorize, and select Track FU. This tells the first flow to register this email.

The first flow runs every 30 minutes. It looks for Outlook emails marked with the Track FU category, reads the recipient email address, and finds the matching row in Excel where the status is "ready". When it finds a match, it saves the send date and tracking details into Excel, changes the status to "active", and changes the Outlook category from Track FU to Registered. This registers the original email so the second flow can create follow-up drafts in the same thread.

The second flow runs every morning (you can change the time). It reads the Excel file and finds prospects where the status is "active". For each one, it checks Outlook to see if the prospect has replied. If a reply is found, it updates the status to "replied" and stops. If no reply is found, it checks which follow-up is next (FU1, FU2, and so on) and looks at the FU Intervals table to see if that follow-up is due today. If it is due, the flow creates a draft reply in Outlook using the follow-up message from Excel. The draft stays in the same email chain. After creating the draft, the flow updates Excel with the last follow-up number and the last draft date.

Open the FU Intervals table in Excel. For each follow-up, set the wait type to "days" or "weekday". If you choose "days", set the wait value to a number like "2" (the draft will be created 2 days after the last action). If you choose "weekday", set the wait value to a day name like "Thursday" (the draft will be created on the next Thursday). You can change these values anytime without editing the flow.

In the second flow, find the action called Append signature variable. If you do not want a signature in the draft, change the value to false. If you want a signature, keep it as true and edit the HTML signature action to update the name, email, title, company name, logo image, font, font size, color, spacing, and logo size.

Send a test email to a prospect, mark it with Track FU, and run the first flow manually. Check Excel to see that the status changed to "active" and the send date was filled. Then run the second flow manually (for testing, you can temporarily change the interval to 0 days in Excel). Check Outlook for the draft reply in the same email thread. Review the draft, make edits if needed, and send it manually.