50 Copilot Prompts for Sales Professionals
If you're spending more time updating your CRM and writing follow-up emails than talking to prospects, you're not alone. Most sales professionals waste 2-3 hours daily on administrative tasks that don't close deals. Microsoft 365 Copilot can automate 60-70% of that busywork—from drafting personalized emails in Outlook to extracting action items from Teams meetings to summarizing lengthy email threads. These 50 prompts are designed specifically for sales professionals who need to spend less time typing and more time selling. Each one leverages actual Copilot features across Outlook, Teams, Word, Excel, and Business Chat.
Email Drafting & Follow-Up Automation
1. Draft personalized introduction email from LinkedIn profile
Use Copilot in Outlook to draft an introduction email by pasting a prospect's LinkedIn summary. Copilot will reference their background and suggest relevant talking points. Saves 10-15 minutes per cold outreach email by eliminating research and writing time.
2. Summarize email thread before responding to long chains
In Outlook, use Copilot to summarize lengthy email threads with multiple stakeholders. Get key decisions, outstanding questions, and next steps in seconds before crafting your response. Prevents redundant questions and missed context.
3. Generate follow-up email after discovery call
After a Teams meeting, use Copilot in Outlook to draft a follow-up email that references meeting discussion points, confirmed pain points, and proposed next steps. Include the meeting transcript reference for accuracy.
4. Create pricing proposal email with professional formatting
Use Copilot in Outlook to draft a pricing proposal email with clear tier breakdowns, value propositions, and next step CTAs. Provide your pricing details and Copilot formats professionally with persuasive language.
5. Write re-engagement email for cold leads
Prompt Copilot in Outlook to draft a re-engagement email for leads who've gone cold. Include context about previous interactions and new relevant offerings. Copilot pulls context from email history automatically.
6. Draft thank-you email after customer referral
Use Copilot in Outlook to quickly draft personalized thank-you emails when customers provide referrals. Include specific details about the referral and express genuine appreciation without sounding generic.
7. Rewrite email to sound less pushy or more confident
After drafting an email, use Copilot's rewrite feature in Outlook to adjust tone—make it more consultative, confident, or empathetic based on the relationship stage. Preview multiple versions before sending.
8. Generate bulk personalized emails for campaign outreach
Use Copilot in Word to create email templates with placeholder fields, then use Copilot in Outlook to personalize each message based on recipient context. Maintain personalization at scale without manual rewrites.
9. Categorize and prioritize inbox by deal urgency
Use Copilot in Outlook to automatically categorize incoming emails by deal stage, urgency, or account value. Set up intelligent triage rules so high-priority prospect emails surface first each morning.
10. Draft objection-handling email for price concerns
When a prospect pushes back on pricing, use Copilot in Outlook to draft a value-focused response that addresses ROI, competitive positioning, and payment flexibility without sounding defensive.
Meeting Preparation & Follow-Up
11. Generate pre-call research brief from SharePoint files
Use Business Chat in Microsoft 365 to query SharePoint and OneDrive for all documents related to an account. Get a summary of past proposals, contracts, and communications before your call. No more scrambling through folders.
12. Create meeting agenda from previous discussion notes
Use Copilot in Word to generate a structured meeting agenda based on previous meeting notes, outstanding action items, and deal stage. Ensure every call has clear objectives and flows logically.
13. Extract action items and commitments from Teams meeting
After a Teams call, use Copilot to automatically extract action items, owners, and deadlines from the meeting transcript. Copy directly into your CRM or follow-up email without re-listening to the recording.
14. Summarize what you missed in a recorded meeting
If you missed a key stakeholder meeting, use Copilot in Teams to get a summary of decisions made, concerns raised, and next steps. Jump back into the conversation without asking colleagues to repeat everything.
15. Draft speaker notes for sales presentation in PowerPoint
Use Copilot in PowerPoint to generate detailed speaker notes for each slide in your pitch deck. Include objection handling, transition phrases, and key talking points so you stay on message.
16. Create post-demo recap document with screenshots
After a product demo, use Copilot in Word to generate a recap document that includes key features shown, questions answered, and next steps. Add screenshots from the meeting recording for reference.
17. Identify buying signals from meeting transcript
Use Copilot in Teams to analyze meeting transcripts for buying signals—phrases like budget confirmed, timeline mentioned, or stakeholder approval requested. Surface opportunities you might have missed in real-time conversation.
18. Generate questions to ask based on prospect's industry
Before a discovery call, use Business Chat to generate industry-specific discovery questions based on the prospect's sector, company size, and known pain points. Come prepared with relevant, targeted questions.
CRM Updates & Pipeline Management
19. Generate CRM update notes from meeting transcript
After a Teams meeting, use Copilot to extract key details—budget, timeline, decision-makers, objections—and format them as CRM-ready notes. Paste directly into Salesforce, HubSpot, or Dynamics without retyping.
20. Summarize deal status from email thread for CRM log
Use Copilot in Outlook to summarize a multi-week email thread with a prospect, then copy the summary into your CRM as a deal update. Captures all context without re-reading 20+ messages.
21. Track competitor mentions across email and meetings
Use Business Chat to search across emails, Teams meetings, and documents for mentions of specific competitors. Understand where you're competing and what objections are coming up across your pipeline.
22. Create weekly pipeline summary for manager
Use Copilot in Word to generate a weekly pipeline report by pulling deal status updates from emails, meeting notes, and previous CRM logs. Include wins, losses, and at-risk deals with context.
23. Identify stalled deals from email activity patterns
Use Copilot in Outlook to flag deals where email activity has dropped off for 7+ days. Get a list of accounts to re-engage before they go completely cold and fall out of pipeline.
24. Generate next steps for each deal stage
Use Business Chat to query your deal playbook and generate recommended next steps for opportunities at each pipeline stage. Get specific tactics based on deal size, industry, and stakeholder engagement level.
25. Draft close plan document for enterprise deals
Use Copilot in Word to create a mutual close plan with timelines, stakeholder responsibilities, technical requirements, and success criteria. Pull context from previous meeting notes and email threads automatically.
26. Analyze win/loss patterns in Excel pipeline data
Use Copilot in Excel to analyze your pipeline data and identify patterns in won vs. lost deals. Ask questions like 'What deal size has highest win rate?' or 'Which industries close fastest?' to optimize targeting.
Proposal & Contract Drafting
27. Generate first draft of sales proposal in Word
Use Copilot in Word to create a customized proposal by providing account details, solution requirements, and pricing structure. Get a professional first draft in minutes instead of starting from blank page.
28. Rewrite proposal sections to match customer's language
Copy prospect's RFP or pain point description, then use Copilot in Word to rewrite your proposal sections using their exact terminology and priorities. Mirror their language to increase relevance and resonance.
29. Create ROI calculator spreadsheet with formulas
Use Copilot in Excel to build an ROI calculator with formulas that show cost savings, productivity gains, and payback period. Provide your product's value drivers and Copilot generates the calculation logic.
30. Draft scope of work document from meeting notes
After scoping calls, use Copilot in Word to convert meeting notes and requirements discussions into a structured scope of work document with deliverables, timelines, and responsibilities clearly defined.
31. Generate case study from customer success story
Use Copilot in Word to turn customer interview notes, usage data, and testimonial quotes into a formatted case study. Include problem, solution, and results sections with compelling narrative flow.
32. Create comparison chart of your solution vs. competitors
Use Copilot in Excel to generate a feature comparison table showing your solution vs. 2-3 competitors. Input feature lists and Copilot formats into professional chart with visual highlighting of your advantages.
33. Draft implementation timeline document
Use Copilot in Word to create a phased implementation timeline with milestones, dependencies, and resource requirements. Pull context from previous successful implementations to set realistic expectations.
34. Generate FAQ document for common sales objections
Use Copilot in Word to create an FAQ document addressing pricing, implementation, security, and integration questions. Based on questions from recent email threads and meeting transcripts, ensure answers are current and relevant.
35. Create executive summary from 20-page proposal
After drafting a detailed proposal, use Copilot in Word to generate a 1-page executive summary highlighting key benefits, investment, and timeline. Perfect for busy C-level stakeholders who won't read the full document.
Presentation & Demo Preparation
36. Generate PowerPoint deck from bullet points
Use Copilot in PowerPoint to create a complete sales deck from a bullet-point outline. Copilot adds slides, suggests layouts, and formats content professionally so you can focus on refining messaging.
37. Customize pitch deck for specific industry vertical
Use Copilot in PowerPoint to adapt your standard pitch deck for a specific industry by replacing generic examples with industry-specific use cases, terminology, and pain points. Maintain slide structure while customizing content.
38. Create demo script from product feature list
Use Copilot in Word to convert a product feature list into a structured demo script with introduction, feature walkthroughs, and closing questions. Include timing estimates and transition phrases for smooth delivery.
39. Generate objection handling cheat sheet
Use Copilot in Word to create a quick-reference guide for handling common objections around price, timing, competition, and implementation. Pull responses from successful deals and refine with persuasive language.
40. Build stakeholder analysis grid in Excel
Use Copilot in Excel to create a stakeholder mapping grid showing decision-makers, influencers, and blockers with their priorities, concerns, and level of support. Update after each meeting to track relationship progress.
41. Draft QBR presentation for existing customers
Use Copilot in PowerPoint to create a Quarterly Business Review presentation showing usage stats, ROI achieved, expansion opportunities, and success stories. Pull data from Excel reports and meeting notes.
42. Create leave-behind one-pager after demo
Use Copilot in Word to generate a one-page summary document recapping the demo, key features shown, pricing discussed, and clear next steps. Send immediately after the meeting while it's fresh.
Data Analysis & Forecasting
43. Analyze monthly sales performance in Excel
Use Copilot in Excel to analyze your monthly sales data and identify trends, top-performing products, seasonal patterns, and underperforming segments. Ask questions in natural language instead of building complex pivot tables.
44. Generate sales forecast based on pipeline data
Use Copilot in Excel to create a weighted pipeline forecast by deal stage, close probability, and historical win rates. Get accurate revenue projections without manual calculation or complex formulas.
45. Create activity dashboard showing calls, emails, meetings
Use Copilot in Excel to build a dashboard tracking daily sales activities—calls made, emails sent, meetings held, proposals delivered. Visualize with charts to identify activity gaps and optimize time allocation.
46. Calculate average deal cycle length by segment
Use Copilot in Excel to analyze closed deals and calculate average sales cycle length by industry, deal size, or product line. Identify which segments close faster to inform prospecting priorities.
47. Identify accounts at risk of churn from usage data
Use Copilot in Excel to analyze customer usage or engagement data and flag accounts showing declining activity. Create a prioritized outreach list before renewal conversations get difficult.
48. Build territory performance comparison report
Use Copilot in Excel to compare sales performance across territories, regions, or team members. Identify top performers and lagging areas, then generate insights about what's working and what needs attention.
49. Generate quota attainment tracker with visual alerts
Use Copilot in Excel to create a quota tracking spreadsheet with conditional formatting that visually highlights pacing—green for on-track, yellow for at-risk, red for behind. Update weekly to stay focused on goals.
50. Analyze email response rates by message type
Export sent email data and use Copilot in Excel to analyze which email types (cold outreach, follow-up, proposal) get highest response rates. Optimize your outreach strategy based on data, not gut feel.
💡 Pro Tips from an MCT
- Start each Copilot prompt with clear context—include account name, deal stage, or specific goal. The more context you provide, the more relevant and accurate Copilot's output will be. Generic prompts get generic results.
- Use Business Chat as your personal sales assistant—ask it to find all documents related to an account, summarize recent interactions, or pull competitor mentions across email and meetings. It searches across your entire Microsoft 365 environment in seconds.
- Always review and personalize Copilot's email drafts before sending. While Copilot saves 80% of the writing time, adding one or two personal touches—a specific reference, a mutual connection, or a relevant insight—dramatically increases response rates.
- Create a library of your best-performing prompts in OneNote or a Word document. When you find a prompt that generates great results, save it with notes about when to use it. Build your own playbook over time.
- Combine Copilot features across apps for maximum impact: use Teams to capture meeting insights, Outlook to draft the follow-up email, Word to create the proposal, and Excel to build the ROI model—all referencing the same deal context for consistency.
Want Your Team Using These Prompts by Friday?
I deliver hands-on Copilot training (MS-4018, MS-4019) where your team walks out with a custom prompt library for your actual workflows. Not theory—practical skills they'll use Monday morning. Custom AI solutions in 90 days. You own the IP.
Book Copilot Training