A small sales team can follow up open quotes by keeping an open-quote list, ranking it by value and age, asking Copilot to draft each reply in Outlook from the quote thread, and logging the result in the CRM after a person approves it. Microsoft's Sales agent automates parts of this for Dynamics 365 Sales and Salesforce.
The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowThe common failure is not writing the follow-up; it is finding which quotes need one. In most small firms the open quotes sit across sent folders and a half-updated CRM, and the chase happens when someone remembers. The method below fixes the list first, then uses Copilot for the writing, and keeps a human approval between the draft and the send.
What can Copilot do for a quote follow-up, and which licence?
Copilot can summarise a quote thread, draft the follow-up and, with the Sales agent, pull deal context from a CRM. Microsoft's pages describe four levels, and which one applies depends on your licence and your CRM.
| Route | What it does for quotes | Licence and set-up (per Microsoft's pages, 22 November 2026) |
|---|---|---|
| Copilot Chat (Basic), including Copilot Chat in Outlook | Ranks quotes from a file you attach; in Outlook, answers questions about your inbox and drafts replies | Included with eligible Microsoft 365 business plans; other work content must be uploaded, pasted or open in Outlook or Teams; fair-use limits |
| Microsoft 365 Copilot (Basic) | Adds Copilot inside Word, Excel, PowerPoint and OneNote, for example on the open-quote sheet | No add-on licence; shown by the label in your apps; fair-use limits |
| Microsoft 365 Copilot (Premium) | Grounds answers in your emails, meetings, chats and files automatically | Add-on licence; Microsoft's Copilot Business page shows $21 a user a month on an annual commitment, or $18 for the first year on annual billing until 31 December 2026 |
| Sales agent | Connects CRM data from Dynamics 365 Sales or Salesforce; email drafting, follow-ups and next-step suggestions in Outlook | A Microsoft 365 admin role to install; CRM roles; "specific licensing requirements" in Microsoft Product Terms |
The Microsoft Copilot Scenario Library page for quicker customer response and CRM updates describes the same chain: review customer history, draft the reply with Copilot Chat in Outlook, and update the CRM record with an AI agent built in Copilot Studio. It lists the scenario as available with Copilot Chat and Copilot Studio. It also says licensed users get Copilot connected to their work data and apps. If you only need the list and the drafts, the first row is enough.
Our tutorial on what staff can do with uploaded files in Copilot Chat explains the limits of the free route in more detail.
How do you build the open-quote list?
Build one table with a row per open quote and these columns: quote number, customer, contact, value, date sent, last contact, next step and owner. Export it from the CRM if you have one, or from the quote folder if you do not, and refresh it weekly.
- Pull the source. A CRM export of deals at the "quote sent" stage is ideal. Without a CRM, list quotes from the sent folder for the last 60 days, using a search on your quote subject line.
- Add the last contact. The date of the last reply from the customer, not your last email. This is the number that shows silence.
- Add the next step. "Site visit booked", "waiting for decision", "price query".
- Remove closed items. Won, lost and withdrawn quotes should not be on the list.
- Keep it small. One sheet, no formatting tricks, headers in row 1. The cleaner the sheet, the better any AI tool reads it.
Copilot Chat in Outlook can help find the threads in the first place. Microsoft's Outlook support page (read 22 November 2026) says that without the add-on licence you can still ask about your inbox, calendar and meetings, and its examples include asking for a summary of last week's emails about one customer. Microsoft Learn's Copilot overview describes the free chat more narrowly, as working with the content you have open, so ask one question about last week's quotes in your own Outlook and compare the answer with your sent folder before you rely on it.
Find the emails I sent in the last 30 days with "Quote" in the subject.
For each one, tell me the customer, the quote number and whether the customer has replied since.
If you are not sure about a reply, say "check" instead of guessing.
Treat the answer as a starting list. A thread renamed by the customer, or a quote sent from a colleague's mailbox, will not show up, which is why the sheet stays the record and the chat only helps fill it.
A worked example: ten open quotes at a security installer
An illustrative twelve-person security installer has ten open quotes worth $73,400 in total. The sales lead exports the list and asks Copilot Chat to apply a simple rule: follow up when there has been no customer reply for five working days, rank by value, and set aside anything older than 30 days for a close-out message instead.
| Quote | Job | Value | Days since sent | Action |
|---|---|---|---|---|
| Q080 | Warehouse cameras | $18,500 | 19 | Second follow-up, offer a site call |
| Q094 | Access control | $14,200 | 16 | Second follow-up, ask about timing |
| Q097 | Eight-camera CCTV | $9,800 | 9 | First follow-up |
| Q085 | Intruder alarm | $3,900 | 12 | First follow-up |
| Q101 | Office alarm refit | $6,400 | 3 | Wait |
| Q083 | Door entry | $5,300 | 6 | Wait one more day |
| Q090 | Monitoring contract | $2,100 | 22 | Second follow-up, short |
| Q088 | CCTV upgrade | $7,600 | 31 | Close-out message |
| Q076 | Alarm service | $1,200 | 40 | Close-out message |
| Q071 | Gate intercom | $4,400 | 27 | Second follow-up |
The four largest quotes due a follow-up, Q080, Q094, Q097 and Q071, are worth $46,900, which is 64% of the $73,400 on the list. The two close-outs total $8,800. The sum is the useful insight: most of the value sits in a handful of quotes, so a short, careful message to four people matters more than ten generic ones.
Attached is our open-quote list. Columns: quote, job, value, date sent, last customer reply, next step.
Today is 22 November. Rules:
- Follow up if no customer reply for 5 working days.
- If more than 30 days since sent, suggest a close-out message instead.
- Rank by value, highest first.
Return a table: quote, value, days since last reply, recommended action, reason in one line.
Do not invent any data. If a date is missing, list the quote as "check".
If you want help fitting a quote follow-up routine into how your installation business runs, I offer one-to-one AI consultations for small businesses.
How do you draft the follow-up in Outlook with Copilot?
Open the original quote thread in Outlook, ask Copilot to summarise it, then ask for a short follow-up that references one specific thing the customer said. Edit the draft, check the figures against the quote and send it yourself.
- Open the quote email thread. Copilot Chat in Outlook works on the email you have open, with or without the add-on licence.
- Ask for a summary of what was promised, what the customer asked and what is still open.
- Ask for a draft follow-up in your tone, under 90 words, with one clear question.
- Check the draft against the quote: quote number, value, date, validity period.
- Send it from your own account, so replies come to you.
Read this thread. In three bullets, tell me: what we quoted, what the customer asked, and what is still open.
Then draft a follow-up under 90 words. Mention the specific question they raised about [topic].
Ask one question only: whether they want to book a site call this week.
Plain tone, no pressure, no discount offer. Use [first name] and sign off as [your name].
Which Copilot button you see in the message window depends on your plan, because Microsoft separates Copilot Chat (Basic) from Microsoft 365 Copilot (Basic) and Premium. The label under your name in the Microsoft Copilot app tells you which one you have. Our tutorial on triaging email and drafting replies with Copilot in Outlook covers the Outlook side in more detail.
Before and after: a generic chase versus a specific one
| Generic (avoid) | Specific (use) |
|---|---|
| Hi [first name], just checking in on the quote I sent over. Let me know if you have any questions. Kind regards | Hi [first name], when we spoke you asked whether the cameras could be fitted before your stock take on the 14th. Our team has a gap on the 8th and 9th. Would a site call on Thursday help you decide? Quote Q080 stays valid until the end of the month. Kind regards, [your name] |
The specific version works because it uses a fact from the thread. That is exactly the job where Copilot helps: it finds the detail in a long thread that a busy salesperson would not re-read. It is also where mistakes enter, such as a date the customer never mentioned, so the check against the thread is not optional.
How do you connect the follow-up to the CRM?
A quote follow-up reaches the CRM in one of three ways: a note logged by hand, a weekly list export, or Microsoft's Sales agent, which links Dynamics 365 Sales or Salesforce to Outlook. Log the note right after sending, so the record matches what the customer received. Microsoft says the Sales agent helps in Outlook with email drafting, follow-ups and next-step recommendations.
Microsoft's Sales agent page gives the conditions: a Microsoft 365 admin role is needed to install and set it up; data sharing with a third-party CRM isn't enabled until administrators and users consent to connect their accounts; with Dynamics 365 Sales, users need the Sales Manager or Salesperson security role, and administrators need System Administrator or System Customizer to customise it; it isn't available on Dynamics 365 Customer Engagement on-premises, or in government cloud environments. It says specific licensing requirements apply and points to the Microsoft Product Terms. That last line means you should ask your Microsoft partner or check the terms before buying anything.
| Your CRM situation | Practical route |
|---|---|
| Dynamics 365 Sales or Salesforce | Evaluate the Sales agent; start with one salesperson as a pilot |
| HubSpot, Pipedrive, Zoho or another CRM | Export the open deals as a CSV weekly; use Copilot Chat on the file; log notes by hand or with the CRM's own automation |
| No CRM, just a spreadsheet | Keep the open-quote sheet as the record; add a log column |
| Wants a custom connection | A Copilot Studio agent; for staff without a Copilot licence, Microsoft bills agents that use shared company data pay-as-you-go, so cost it before building |
Whichever route, the note you log should be the same short shape. This illustrative note takes fifteen seconds:
22 Nov. Follow-up 2 sent on Q080 (warehouse cameras, $18,500). Offered site call Thursday. Customer asked about install before stock take on the 14th. Next: call Thursday if no reply; close-out if silent by 6 Dec. Owner: [name].
For the wider picture of logging calls and emails automatically, see our tutorials on updating your CRM automatically after sales calls and which AI CRM features save time.
How do you keep an approval step before anything is sent?
Treat every Copilot draft as unsent until a named person has checked the figures, the name and the promise. A one-line gate on a checklist is enough for a small team, and it keeps a wrong price from going to a customer.
- Quote number and value match the quote document.
- Validity date has not passed. If it has, the draft offers to refresh the quote instead of referring to it.
- Name and company are right, not a similarly named contact from the thread.
- Promises (dates, discounts, lead times) exist in writing elsewhere. Copilot must not create any.
- Tone suits the relationship and is not pushy.
- Sender is the person who owns the quote.
For the Sales agent specifically, Microsoft's page describes it as helping with email drafting, follow-ups and next-step recommendations; it does not say that it sends messages without a person, and you should not configure anything that does until you have run it for several weeks and read every draft. The slower route protects the customer relationship, which is the asset a quote follow-up exists to protect.
How often should you follow up an open quote?
A workable small-team cadence is a first follow-up five working days after sending, a second around day 14, a third near day 21 for large quotes, and a close-out around day 30. This is a working habit rather than a Microsoft figure, so adjust it to your sales cycle.
| Stage | Purpose | Length | Question to ask |
|---|---|---|---|
| Day 5 (first) | Check receipt and offer help | 60-90 words | Any questions on the price or scope? |
| Day 14 (second) | Reference something specific from their thread | 60-90 words | Would a call or site visit help you decide? |
| Day 21 (third, big quotes only) | Offer a change that may unblock them | 60 words | Is it timing, scope or budget? |
| Day 30 (close-out) | Release the quote politely and leave the door open | 40-60 words | Shall I close this, or do you want to keep it open? |
The close-out is the most neglected message and often the one that gets a reply, because it gives the customer an easy way to say "not now" or "yes, sorry". It also cleans the list, so your open value reflects reality. Stop chasing anyone who has said no.
How do you make the sheet calculate the follow-up date for you?
Add two formula columns to the open-quote sheet: days since last reply and next action. Then Copilot, or you, only has to read the results. A formula never forgets a date and takes five minutes to set up.
Assume columns A to H hold quote, customer, job, value, date sent, last customer reply, next step and owner, with headers in row 1. Add these in columns I and J, filled down.
I2: =IF(F2="", TODAY()-E2, TODAY()-F2)
J2: =IF(I2>30,"Close-out",IF(I2>=14,"Second follow-up",IF(I2>=5,"First follow-up","Wait")))
Column I returns days of silence, using the date sent if the customer has never replied. Column J turns that into an action using the day-5, day-14 and day-30 cadence from earlier. Sort by value, filter out "Wait", and the list for Monday's session is ready before Copilot is involved. Attaching the sheet then gives Copilot the answers to check rather than rules to apply, which tends to produce fewer arithmetic slips.
A word on the limits of the formula. It counts calendar days, not working days, so a quote sent on a Thursday shows five days of silence by Tuesday, when only three working days have passed. If your rule is five working days, replace TODAY()-E2 with NETWORKDAYS(E2,TODAY())-1 (and the same for F2), because NETWORKDAYS counts both the first and the last day; then treat the 14 and 30 thresholds as roughly 10 and 21 working days. The formula also cannot tell that a customer said "come back to me in January", so add a column K for an agreed next-contact date and use this version of J2 instead:
J2: =IF(K2>TODAY(),"Wait until "&TEXT(K2,"d mmm"),IF(I2>30,"Close-out",IF(I2>=14,"Second follow-up",IF(I2>=5,"First follow-up","Wait"))))
With a date in K2, the row reads "Wait until 12 Jan", so filtering column J to rows that do not begin with "Wait" drops it from Monday's list until then; with K2 blank, the original rules apply. A quick test before you trust it: add four dummy rows at the bottom, three with a last reply 3, 15 and 40 days ago and one with a next-contact date next month, and check that column J says Wait, Second follow-up, Close-out and Wait until.
If setting up formula columns like these is the slow part, try The Complete Excel Course with AI Integration on Coding Liquids.
An interior designer's room-scheme quote, chased on the decision
Quotes for design work depend on decisions the customer has not made, so the follow-up asks about the decision, not the price. An illustrative interior designer sent a $12,800 quote for a living-room scheme 14 days ago. The thread shows that the customer liked the layout, worried about the lead time for a sofa, and said they would talk to a partner.
Summarise this thread: what the customer liked, what worried them, and what they said they would do next.
Then draft a reply under 80 words. Address the sofa lead time directly by offering to share the supplier's lead-time list.
Do not mention price. Do not offer a discount. Sign off as [your name].
An illustrative draft returned by Copilot says the customer "liked the layout and wanted to talk to their partner", which matches the thread, then adds "and wanted to proceed in January", which does not. The designer deletes the invented month, keeps the offer to share the lead-time list, and adds the actual sofa supplier's stated lead time from her own file. The check took two minutes and removed the one sentence that would have created a false commitment. This is the pattern in every example here: Copilot reads and drafts quickly, and the person owns the facts.
A close-out message you can adapt
A good close-out is short, gives the customer an easy exit and keeps the door open. Here is a template filled in for the security installer.
Subject: Quote Q088 for the CCTV upgrade
Hi [first name],
I sent this quote a month ago and haven't heard back, so I will close it on our side to keep things tidy.
If the project is still on, reply to this message and I'll refresh the figures, as the supplier price has moved since.
If timing has changed, tell me roughly when to come back to you and I'll make a note.
Thanks for considering us,
[your name]
The "supplier price has moved" line is the kind of fact to confirm before it is sent. If it is not true, delete it. Nothing in a close-out should be there to create pressure.
How do you pilot the Sales agent without committing?
Pilot the Sales agent with one salesperson for four weeks, compare against the manual routine, and record time saved and errors caught. This is only relevant if your CRM is Dynamics 365 Sales or Salesforce, which are the two Microsoft's page names.
| Week | What the pilot salesperson does | What the owner records |
|---|---|---|
| 0 | Admin installs and sets up the agent; user and admin consent to connect to the CRM; roles confirmed | Who needed which role; how long set-up took; licence questions put to the Microsoft partner |
| 1 | Uses it on five open quotes for drafting only; does not change the usual routine | Draft quality, errors found at the approval gate |
| 2 | Uses CRM context in the drafts for ten quotes | Was the CRM context correct? Any stale fields? |
| 3 | Logs outcomes in the CRM as usual | Minutes per follow-up versus the manual routine |
| 4 | Review with the owner | Decision: stop, extend or add a second salesperson |
Microsoft's page says changes to a user's roles in the CRM may need a sign-out and sign-in again in Outlook to take effect, and that permission changes can take up to 15 minutes to show in the Sales agent for Teams. Put that in the pilot notes so nobody spends an afternoon debugging a role change that has not caught up yet.
How do you tell whether the routine is paying back?
A quote follow-up routine is paying back when four monthly numbers hold up: quotes chased, replies received, quotes won and value still open. If chasing takes thirty minutes a week and keeps even one quote alive a quarter, compare that with the cost of the time and any licence.
An illustrative sum: the installer spends 30 minutes a week, about 26 hours a year, on the routine. At $35 an hour that is $910 of time. If the routine contributes to winning one extra $5,300 door-entry job a year at a 30% gross margin, that is $1,590 of margin, enough to cover the time. It does not prove cause, so avoid claiming the follow-up won the job; the useful comparison is whether the routine costs less than the value of the quotes it keeps alive. For a paid licence at $18 to $21 a user a month on an annual commitment, the same logic applies, with one more input: how many hours a month the licence saves that person across all their Copilot use, not only quotes.
What mistakes do teams make when they follow up quotes with Copilot?
The usual mistakes with Copilot quote follow-ups are chasing a quote that was already won, quoting a stale price, letting the draft invent a promise, and following up everyone on the same day. Each comes from skipping the list or the approval step.
Chasing a won quote. The deal was agreed by phone, nobody updated the sheet, and the customer receives "just checking in". The fix: update status in the sheet the same day, and have Copilot only work from the refreshed list.
The stale price. The draft repeats the original figure, but supplier costs rose and the quote expired last week. The fix: the approval gate checks validity, and the draft offers a refresh rather than repeating the old number.
The invented promise. Copilot writes "we can fit it before the 14th", a date that nobody agreed. The fix: promises must exist in writing elsewhere, and the prompt says "do not offer dates or discounts".
The Monday blast. Ten follow-ups on one morning feels like a campaign. Spread them across the week and send the biggest first.
What does a thirty-minute weekly routine look like?
A thirty-minute weekly quote routine has five steps: refresh the list, ask Copilot to rank it, draft follow-ups for the top four to six quotes, approve and send them, and log a note for each. Thirty minutes on Monday is enough for a team with fewer than 30 open quotes.
- Export or update the open-quote list (five minutes).
- Attach the list to Copilot Chat and run the ranking prompt (two minutes).
- Open the top four threads and draft follow-ups in Outlook (ten minutes).
- Approve each against the gate list and send (eight minutes).
- Log a note in the CRM or the sheet and set the next date (five minutes).
Review once a month: how many quotes were chased, how many replied, how many were won, and how much value is still open. Those four numbers show whether the habit is paying back, and give you something concrete to compare if you later decide to pay for the Sales agent or a Copilot licence. Our tutorial on automating sales follow-ups without being pushy covers the tone side, and the one on signs your business is ready to automate follow-ups helps you judge when to go further.
Questions about quote follow-ups with Copilot
Do I need Dynamics 365 or Salesforce to use Copilot for quote follow-ups?
No. Microsoft's Sales agent connects to Dynamics 365 Sales or Salesforce, but you can follow up quotes without it by keeping an open-quote list in Excel or a CRM export, attaching it to Copilot Chat and drafting replies in Outlook. The CRM link then becomes a note you log by hand or an export you refresh weekly.
Will Copilot send the follow-up emails by itself?
No, not in the routes described here. Microsoft's sales scenario has Copilot Chat in Outlook draft the customer email, and its Sales agent page describes email drafting, follow-ups and next-step suggestions rather than unattended sending. Keep a person on the send button: a draft carries the wrong price or the wrong name as easily as a right one, and an approval step catches that.
Which Copilot licence does a sales team need for this?
None for the basic routine. Copilot Chat (Basic), included with eligible Microsoft 365 business plans, can rank an uploaded quote list and draft replies in Outlook. Automatic grounding across mail, meetings, chats and files needs Microsoft 365 Copilot (Premium), and Microsoft says the Sales agent has specific licensing requirements in its Product Terms, so confirm those with your Microsoft partner before buying.
How soon should a quote be followed up?
A common small-team rule is a first follow-up after about five working days of silence, then at roughly day 14 and a final close-out near day 30. That is a working habit, not a Microsoft figure. Adjust it to the length of your buying cycle, and stop chasing anyone who has said no.
Is it safe to give Copilot customer quotes?
Yes, within limits. With a work account, Copilot Chat is covered by Microsoft's enterprise data protection, which Microsoft says applies the same contractual terms as email in Exchange and files in SharePoint. Even so, share only what the job needs, such as quote number, value, date and last message, and leave out bank details, identity documents and anything a customer marked confidential.
Further reads
- What It Costs to Set Up an AI CRM for a Small Team — What an AI CRM costs to set up for a small team.
- How Small Businesses Use AI in Sales: 10 Real Examples — Ten ways small businesses use AI in sales.
- Copilot in Word: Draft Proposals From Your Own Files — Draft the proposal itself from your own files.
- What Is Copilot Studio and Does a Small Business Need It? — When a custom agent is worth building.
- How Much Do Copilot Agents Cost? Credits and Billing Explained — How agent billing and credits are counted.
- HubSpot vs Pipedrive for AI Sales Automation in a Small Business — If your CRM is not a Microsoft one.
Show 3 more related tutorials
- How to Write a Sales Deck With AI That Wins Meetings — Prepare the meeting that follows a quote.
- Sales Visit Report Template: What to Include and How AI Fills It — A nine-field visit report, the prompt that fills it from a two-minute voice note, and one retailer visit followed from recording to CRM.
- How to Use ChatGPT for Sales Follow-Ups on Open Quotes — Use a weekly open-quotes review to choose legitimate follow-ups, draft messages by stage and record the next action without automatic sending.
Browse all AI-for-business tutorials
Sources: Microsoft Adoption page Sales scenario: Quicker customer response and CRM updates; Microsoft Learn pages Welcome to Sales agent and What is Microsoft Copilot?; Microsoft Support page Chat with Copilot in Outlook; Microsoft's Copilot Business pricing page (all read 22 November 2026).
