50 Copilot Prompts for Real Estate Agents

Real estate agents spend an average of 12 hours per week on CRM updates, follow-up emails, and client communications—time that could be spent showing properties and closing deals. Microsoft 365 Copilot integrates directly into Outlook, Word, Teams, and Excel to automate these repetitive tasks. These 50 prompts are designed specifically for real estate professionals who want to reclaim their time while maintaining the personal touch that wins listings. Each prompt leverages actual Copilot features you already have access to with your Microsoft 365 subscription.

Client Follow-Up & Relationship Management

1. Post-Showing Follow-Up Email

Use Copilot in Outlook to draft: 'Create a warm follow-up email for [Client Name] who toured [Property Address] today. Reference the updated kitchen and large backyard they loved. Ask about their timeline and offer to schedule a second showing.' Copilot uses context from your previous emails to maintain consistent tone.

beginner ⏰ Saves 5 minutes per showing Feature: Email drafting in Outlook

2. Monthly Market Update for Sphere of Influence

In Word with Copilot: 'Draft a monthly market update newsletter for my sphere of influence. Include recent sales in [Neighborhood], current inventory levels, and average days on market. Keep tone conversational and include a call-to-action for free home valuations.' Copilot generates professional content you can personalize.

beginner ⏰ Saves 45 minutes monthly Feature: Document generation in Word

3. Birthday and Anniversary Outreach

Copilot in Outlook: 'Write a brief, personal birthday message to [Client Name]. Reference that we helped them buy their home on [Street Name] two years ago and wish them well. Offer assistance if they know anyone looking to buy or sell.' Maintains relationships without sounding automated.

beginner ⏰ Saves 3 minutes per client Feature: Email drafting in Outlook

4. Re-Engagement Campaign for Dormant Leads

Use Business Chat: 'Review my Outlook emails from [6 months ago] and identify clients who were actively looking but went quiet. Draft a re-engagement email series asking if their plans have changed and sharing new inventory matching their criteria.' Copilot searches across your M365 data.

intermediate ⏰ Saves 2 hours per campaign Feature: Business Chat with natural language queries

5. Post-Closing Thank You Package

In Word: 'Create a thank you letter for [Client Names] who just closed on [Address]. Congratulate them, remind them about upcoming home maintenance in their first season, and request a review on [Platform]. Include referral incentive details.' Personal touch at scale.

beginner ⏰ Saves 10 minutes per closing Feature: Document generation in Word

6. Quarterly Check-In Automation

Copilot in Outlook: 'Draft a check-in email for past clients who bought 12-18 months ago. Ask how they're enjoying their home, offer a free CMA to see their equity growth, and request referrals. Keep it helpful, not salesy.' Builds repeat and referral business systematically.

beginner ⏰ Saves 4 minutes per client Feature: Email drafting in Outlook

7. Referral Request After Positive Interaction

Use Copilot in Outlook: 'Based on my last email exchange with [Client Name], draft a referral request. They mentioned loving their new neighborhood—ask if they know anyone else who'd appreciate help finding their perfect home. Keep it natural and appreciative.' Timing is everything with referrals.

beginner ⏰ Saves 5 minutes per request Feature: Email drafting in Outlook

8. Annual Home Anniversary Email

Copilot in Outlook: 'Create a one-year home anniversary email for [Client Name] at [Address]. Celebrate their milestone, provide a current market value estimate, and remind them you're available for questions or referrals. Include seasonal maintenance tips.' Keeps you top-of-mind.

beginner ⏰ Saves 6 minutes per client Feature: Email drafting in Outlook

Listing Presentations & Marketing Materials

9. Comparative Market Analysis Narrative

In Word with Copilot: 'Write a CMA summary for [Address]. Based on the comparable sales data I'll paste, explain why I recommend listing at [Price]. Address the property's updated features and current market conditions in [Neighborhood]. Professional but approachable tone.' Turns data into compelling story.

intermediate ⏰ Saves 20 minutes per CMA Feature: Document generation and editing in Word

10. Property Description for MLS

Copilot in Word: 'Create an engaging MLS description for [Address]: [X] bed, [X] bath, [Square Feet]. Highlight updated kitchen with quartz counters, hardwood floors, large backyard, and proximity to [School/Park]. Emphasize lifestyle benefits, not just features. 250 words max.' Converts features to emotional appeal.

beginner ⏰ Saves 15 minutes per listing Feature: Document generation in Word

11. Social Media Listing Announcement

Use Copilot in Word: 'Write 3 versions of a social media post announcing my new listing at [Address] in [Neighborhood]. Version 1 for Instagram (with emoji), Version 2 for Facebook (conversational), Version 3 for LinkedIn (professional). Include key features and price.' Multi-platform content instantly.

beginner ⏰ Saves 12 minutes per listing Feature: Document generation in Word

12. Listing Presentation Deck

Copilot in PowerPoint: 'Create a listing presentation for a seller at [Address]. Include slides on: my background, local market trends, pricing strategy, marketing plan, and timeline. Professional design with charts showing recent comparable sales.' Impresses sellers from slide one.

intermediate ⏰ Saves 90 minutes per presentation Feature: Presentation creation in PowerPoint

13. Open House Invitation Email

Copilot in Outlook: 'Draft an open house invitation for [Address] on [Date/Time]. Highlight the home's best features, neighborhood amenities, and include a map link. Encourage recipients to share with anyone they know looking in [Area]. Warm and inviting tone.' Drives attendance.

beginner ⏰ Saves 8 minutes per open house Feature: Email drafting in Outlook

14. Price Reduction Announcement

In Outlook with Copilot: 'Write an email announcing a price reduction on [Address] from [Old Price] to [New Price]. Emphasize this creates a great opportunity, highlight the home's value, and create urgency without sounding desperate. Send to my buyer client list.' Repositions without stigma.

intermediate ⏰ Saves 12 minutes per reduction Feature: Email drafting in Outlook

15. Coming Soon Teaser Campaign

Copilot in Word: 'Create a 'coming soon' teaser for my upcoming listing in [Neighborhood]. Don't reveal address yet. Build anticipation around key features: [updated kitchen, pool, location]. Include email signup for exclusive early access. Mysterious but enticing.' Generates pre-listing buzz.

beginner ⏰ Saves 10 minutes per listing Feature: Document generation in Word

16. Virtual Tour Narration Script

Use Copilot in Word: 'Write a narration script for a video walkthrough of [Address]. Guide viewers room-by-room, highlighting: entryway with original hardwood, chef's kitchen, primary suite with spa bath, backyard oasis. 3-4 minutes of natural, engaging commentary.' Professional video content.

intermediate ⏰ Saves 25 minutes per video Feature: Document generation in Word

Buyer Communication & Showing Coordination

17. New Listing Alert for Active Buyers

Copilot in Outlook: 'Draft an email to [Buyer Name] about a new listing at [Address] that matches their criteria: [X] beds, [X] baths, [Budget], [Neighborhood]. Highlight why it's a great fit and suggest showing times for tomorrow or this weekend.' Timely alerts win offers.

beginner ⏰ Saves 5 minutes per alert Feature: Email drafting in Outlook

18. Showing Schedule Confirmation

Use Copilot in Outlook: 'Create a showing day itinerary email for [Buyer Names] on [Date]. We're seeing: 1) [Address] at 10am, 2) [Address] at 11:30am, 3) [Address] at 1pm. Include addresses, key features of each, and map links. Professional and organized.' Reduces no-shows and confusion.

beginner ⏰ Saves 10 minutes per showing day Feature: Email drafting in Outlook

19. Buyer Onboarding Welcome Packet

Copilot in Word: 'Create a buyer welcome packet explaining my process: initial consultation, pre-approval importance, home search, offer strategy, inspection, closing timeline. Include my communication style and what to expect. Friendly but professional.' Sets expectations from day one.

intermediate ⏰ Saves 45 minutes one-time Feature: Document generation in Word

20. Pre-Approval Encouragement Email

In Outlook with Copilot: 'Write an email to [Buyer Name] explaining why pre-approval is critical before we start touring homes. Include benefits: know exact budget, sellers take offers seriously, faster closing. Offer to connect them with trusted lenders. Not pushy, educational.' Qualifies buyers properly.

beginner ⏰ Saves 6 minutes per buyer Feature: Email drafting in Outlook

21. Property Comparison Spreadsheet Summary

Copilot in Excel: 'Analyze this spreadsheet of 5 properties [Buyer Name] has seen. Create a summary comparing price, bedrooms, bathrooms, lot size, schools, and commute time. Highlight the best value and best overall fit based on their stated priorities.' Data-driven decisions.

intermediate ⏰ Saves 20 minutes per comparison Feature: Data analysis in Excel

22. Offer Strategy Explanation

Use Copilot in Word: 'Draft a document explaining offer strategy for [Address] in this competitive market. Cover: suggested offer price, earnest money, inspection period, financing vs. cash considerations, and escalation clause options. Help [Buyer Name] understand why we're recommending [Strategy].' Educates and builds trust.

intermediate ⏰ Saves 25 minutes per offer Feature: Document generation in Word

23. Lost Offer Encouragement

Copilot in Outlook: 'Write an empathetic email to [Buyer Name] whose offer on [Address] wasn't accepted. Acknowledge disappointment, remind them the right home is coming, and suggest 3 new listings to tour this week. Keep spirits up and momentum going.' Retention during tough markets.

beginner ⏰ Saves 8 minutes per situation Feature: Email drafting in Outlook

24. Inspection Results Summary

In Word with Copilot: 'Summarize this 40-page inspection report for [Address] into key findings for [Buyer Name]. Categorize as: critical issues requiring immediate attention, moderate concerns to negotiate, and minor items for future maintenance. Plain language, not technical jargon.' Makes reports actionable.

intermediate ⏰ Saves 35 minutes per inspection Feature: Document editing and rewriting in Word

25. Neighborhood Research Summary

Use Business Chat: 'Research [Neighborhood Name] and create a summary for my buyers including: average home prices, school ratings, nearby amenities, commute times to [Downtown], and recent development. Compile from web sources and local knowledge.' Positions you as area expert.

intermediate ⏰ Saves 30 minutes per area Feature: Business Chat with natural language queries

Transaction Coordination & CRM Updates

26. Contract Status Update to Clients

Copilot in Outlook: 'Draft a status update email for [Buyer/Seller Name] on their transaction at [Address]. We've completed: inspection, appraisal came in at value, title search clear. Next steps: final walkthrough on [Date], closing on [Date]. Everything on track, no concerns.' Reduces anxiety calls.

beginner ⏰ Saves 7 minutes per update Feature: Email drafting in Outlook

27. Meeting Summary for Transaction File

After a Teams meeting with lender/title company, use Copilot: 'Summarize this meeting recording into action items: who's responsible for what, deadlines, and any issues flagged. Format for my transaction file notes.' Meeting transcription and summaries save massive time.

beginner ⏰ Saves 15 minutes per meeting Feature: Meeting transcription and summaries in Teams

28. Closing Checklist Email

Use Copilot in Outlook: 'Create a pre-closing checklist email for [Buyer/Seller Name] closing on [Date]. Include: bring photo ID, certified funds for $[Amount], don't make major purchases, transfer utilities, schedule movers. Clear action items with deadlines.' Prevents closing day disasters.

beginner ⏰ Saves 8 minutes per closing Feature: Email drafting in Outlook

29. Transaction Timeline Overview

Copilot in Word: 'Create a transaction timeline document for [Address] from contract to closing. Include: key dates (inspection, appraisal, financing deadline, final walkthrough, closing), responsible parties, and contingency removal deadlines. Visual and easy to understand.' Keeps everyone aligned.

intermediate ⏰ Saves 20 minutes per transaction Feature: Document generation in Word

30. CRM Notes from Email Thread

Use Business Chat: 'Review my Outlook email thread with [Client Name] over the past month. Summarize their property preferences, budget changes, timeline updates, and any concerns raised. Format as CRM notes.' Copilot extracts key details from long conversations.

intermediate ⏰ Saves 12 minutes per client update Feature: Business Chat with natural language queries

31. Vendor Coordination Email

Copilot in Outlook: 'Draft an email to coordinate [Inspector/Appraiser/Photographer] for [Address]. Provide property access details, seller's schedule constraints, and request confirmation of [Date/Time]. Include my contact info and property lockbox code.' Streamlines vendor management.

beginner ⏰ Saves 6 minutes per vendor Feature: Email drafting in Outlook

32. Commission Calculation Worksheet

In Excel with Copilot: 'Create a commission worksheet for a $[Sale Price] transaction. Calculate: gross commission at [X]%, split with [Cooperating Broker], my brokerage split at [Y]%, subtract transaction fees of $[Amount]. Show net commission to me.' Quick pipeline value calculations.

beginner ⏰ Saves 5 minutes per deal Feature: Formula generation in Excel

33. Delay Notification to All Parties

Use Copilot in Outlook: 'Write a professional email notifying all parties (buyer, seller, lender, title) that closing on [Address] is delayed from [Original Date] to [New Date] due to [Appraisal/Financing/Title Issue]. Apologize for inconvenience, provide new timeline, maintain confidence.' Crisis communication done right.

intermediate ⏰ Saves 15 minutes per delay Feature: Email drafting in Outlook

Market Analysis & Business Planning

34. Monthly Production Report

Copilot in Excel: 'Analyze my sales data spreadsheet for [Month]. Calculate: total volume, number of transactions, average sale price, buyer vs. seller sides, and commission earned. Compare to last month and same month last year. Create a summary chart.' Track business health instantly.

intermediate ⏰ Saves 40 minutes monthly Feature: Data analysis and chart creation in Excel

35. Quarterly Goal Review Document

Use Copilot in Word: 'Create a Q[X] review document. I closed [X] transactions totaling $[Amount] against a goal of [X] transactions. Analyze what's working: referrals up [X]%, new construction expertise growing. Set Q[X+1] goals with specific action items.' Accountability drives growth.

intermediate ⏰ Saves 60 minutes quarterly Feature: Document generation in Word

36. Competitive Market Analysis Report

Copilot in Excel: 'Using this spreadsheet of recent sales in [Neighborhood], calculate: average price per square foot, average days on market, list-to-sale price ratio, and inventory levels. Identify pricing trends over the past 6 months.' Present data like a market expert.

advanced ⏰ Saves 45 minutes per analysis Feature: Data analysis in Excel

37. Lead Source ROI Analysis

Use Copilot in Excel: 'Analyze my lead tracking spreadsheet. Calculate cost per lead and cost per closed transaction for each source: Zillow, Facebook ads, sphere referrals, past clients, open houses. Which sources have best ROI?' Spend marketing budget smarter.

advanced ⏰ Saves 90 minutes per analysis Feature: Data analysis in Excel

38. Annual Business Plan

Copilot in Word: 'Draft my [Year] business plan. Goals: [X] transactions, $[X] GCI. Strategies: increase SOI contact from monthly to bi-weekly, launch buyer seminar series, add team member by Q3. Include budget, timeline, and success metrics.' Strategic planning made concrete.

advanced ⏰ Saves 3 hours annually Feature: Document generation in Word

39. Pricing Strategy for Different Property Types

In Word with Copilot: 'Create a pricing strategy guide for my market. Cover: how to price luxury homes over $1M, starter homes under $300K, and condos. Include market-specific considerations and seasonal factors. Use as internal reference.' Systematize your expertise.

intermediate ⏰ Saves 2 hours one-time Feature: Document generation in Word

40. Client Database Segmentation

Use Business Chat: 'Review my Outlook contacts and OneDrive client files. Segment into: A-tier (past clients/active referrers), B-tier (warm leads), C-tier (cold leads). Suggest different communication frequencies and strategies for each tier.' Work your database scientifically.

advanced ⏰ Saves 2 hours per segmentation Feature: Business Chat with natural language queries

41. Seasonal Marketing Calendar

Copilot in Excel: 'Create a 12-month marketing calendar. Include: monthly themes (spring buying season, summer family focus, fall market, holiday staying in touch), content ideas, and budget allocation. Track execution and results throughout the year.' Plan marketing like a pro.

intermediate ⏰ Saves 4 hours annually Feature: Data organization in Excel

Team Collaboration & Professional Development

42. Team Meeting Action Items

After your brokerage meeting in Teams, ask Copilot: 'Summarize action items from this meeting. Who's responsible for new CRM training, who's updating the listing agreement template, and when's the next compliance deadline?' Never miss follow-through again.

beginner ⏰ Saves 10 minutes per meeting Feature: Meeting summaries and action items in Teams

43. Client Handoff to Transaction Coordinator

Use Copilot in Outlook: 'Draft an introduction email connecting [Client Name] with my transaction coordinator [TC Name] for their purchase of [Address]. Summarize the deal: price, financing, key dates, and any special considerations. Make the transition seamless.' Delegation without dropping balls.

beginner ⏰ Saves 8 minutes per handoff Feature: Email drafting in Outlook

44. Training Notes Summary

After a continuing education course in Teams, use Copilot: 'Summarize the key takeaways from this training on [Topic]. Extract action items I can implement in my business this month. Format as a one-page reference sheet.' Learning that sticks.

beginner ⏰ Saves 20 minutes per training Feature: Meeting transcription and summaries in Teams

45. Broker Feedback Request

Copilot in Outlook: 'Write an email to my broker asking for feedback on my listing presentation for [Address]. Specifically request input on pricing strategy and marketing plan. Professional tone, open to coaching.' Accelerate your growth.

beginner ⏰ Saves 5 minutes per request Feature: Email drafting in Outlook

46. Collaborative Client Notes in Copilot Pages

Use Copilot Pages: 'Create a shared workspace for the [Address] transaction. Include: timeline, contact info for all parties, open items list, and communication log. Share with my transaction coordinator and assistant for real-time collaboration.' Everyone stays updated.

intermediate ⏰ Saves 15 minutes setup, 2 hours saved per transaction Feature: Copilot Pages for collaborative content

47. Joint Venture Agreement Draft

Use Copilot in Word: 'Draft a co-listing agreement between me and [Agent Name] for [Address]. Cover: responsibility split, commission split at [X]%, lead marketing responsibilities, and communication protocol with seller. Professional and clear.' Partnerships done right.

intermediate ⏰ Saves 30 minutes per partnership Feature: Document generation in Word

48. Mentorship Session Recap

After mentoring a new agent, use Copilot in Teams: 'Summarize our mentorship session. Extract the questions [Mentee Name] asked, advice I gave on prospecting and objection handling, and action items for their first 90 days.' Pay it forward efficiently.

beginner ⏰ Saves 12 minutes per session Feature: Meeting summaries in Teams

49. Brokerage Newsletter Contribution

Copilot in Word: 'Write a 300-word article for our brokerage newsletter about the current state of the [Neighborhood] market. Include recent sales trends, inventory levels, and buyer/seller tips. Establish me as the local expert.' Build your brand internally.

intermediate ⏰ Saves 25 minutes per article Feature: Document generation in Word

💡 Pro Tips from an MCT

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
Scott Hay Microsoft Certified Trainer & AI Solutions Architect Microsoft Certified Trainer (MCT) • Delivers 12 Microsoft Copilot courses (MS-4002 through MS-4023) plus Azure AI, Power BI • Azure AI Agents, Semantic Kernel, Power BI (PL-300), Power Platform certified • Former Microsoft and Amazon — 30+ years building production systems • Builds custom AI solutions for SMBs with 90-day delivery