How to Use Copilot Prompts for Sales Account Plan Generation

Sales account plans require detailed research on a customer’s business, their challenges, and your solution’s fit. Manually gathering this data from CRM records, meeting notes, and financial filings can take hours. Copilot in Microsoft 365 can automate this process by generating structured account plans from natural language prompts. This article explains the key prompts to use, how to structure them for accurate results, and how to refine Copilot’s output for your sales process.

What Copilot Prompts Do for Account Plan Generation

Copilot uses generative AI to read your Microsoft Graph data, including emails, calendar events, documents, and CRM records stored in Microsoft 365. When you write a prompt for an account plan, Copilot retrieves relevant information from these sources and assembles it into a structured response. The quality of the output depends on how specific and detailed your prompt is. A vague prompt like “create an account plan for Contoso” returns generic content. A prompt that specifies the customer name, the time frame for data, and the sections you need yields a plan that requires minimal editing. Before you start, ensure your Microsoft 365 tenant has Copilot for Microsoft 365 licenses assigned to the sales team and that the CRM data you want Copilot to read is synced to Microsoft Graph (for example, via Dynamics 365 or a supported third-party connector).

Steps to Generate a Sales Account Plan with Copilot

Follow these steps to create a complete account plan. You will use Copilot in Word for the main document, Copilot in Outlook for email context, and Copilot in Teams for meeting notes.

Method 1: Create the Account Plan Document in Word

1. Open a new Word document
   Launch Word and create a blank document. Click the Copilot icon in the ribbon or press Alt+I to open the Copilot pane.
2. Write the account plan prompt
   In the Copilot compose box, type: “Create a sales account plan for Contoso. Include sections for executive summary, customer business overview, key stakeholders, current challenges, our proposed solution, competitive landscape, sales strategy, and next steps. Use data from the last six months of emails and meetings.” Replace Contoso with your actual customer name. Press Enter.
3. Review and refine the generated plan
   Copilot inserts a draft with placeholders. Check each section. If a section is too short, click the Copilot icon in the document margin and type “Expand the customer business overview section with more detail from recent meeting notes.” If a section is missing, type “Add a section about budget and decision timeline.”
4. Insert CRM data manually if needed
   If your CRM is not connected to Microsoft Graph, copy key fields from your CRM system (account name, annual revenue, industry, contact names) and paste them into the relevant sections. Then ask Copilot: “Update the customer profile with the data I just pasted.”

Method 2: Gather Context from Email Threads Using Copilot in Outlook

1. Open the customer’s most recent email thread
   In Outlook, select the longest or most recent email thread with the customer. This thread should contain the latest discussions about their needs and your proposal.
2. Use Copilot to summarize the thread
   Click the Copilot icon in the Outlook ribbon and select “Summarize this thread.” Alternatively, in the Copilot pane, type “Summarize this email thread and list the key decisions, open action items, and the customer’s main pain points.”
3. Copy the summary into your account plan
   Select the Copilot output, copy it, and paste it into the “Current challenges” or “Key stakeholders” section of your Word document. Then ask Copilot in Word: “Incorporate this pasted content into the existing section and rephrase it to match the account plan’s tone.”

Method 3: Extract Meeting Notes with Copilot in Teams

1. Navigate to the Teams meeting chat
   Open Microsoft Teams and go to the chat or channel where the account team discussed the customer. Locate the meeting recap or the transcript of the most recent call.
2. Ask Copilot for action items
   In the Copilot pane within Teams, type “Show me the action items from the meeting titled ‘Contoso Q3 Review’ held on [date].” If you do not have the exact date, type “Show me all action items from meetings with Contoso in the last 30 days.”
3. Add the action items to your plan
   Copy the list of action items, including who is responsible and the due date. Paste them into the “Next steps” section of your Word account plan. Then ask Copilot in Word: “Format this pasted list as a table with columns for Action, Owner, and Deadline.”

Common Mistakes and How to Avoid Them

Copilot returns generic content that does not mention the customer

This happens when the prompt does not include a specific customer name or when Copilot cannot find data about that customer in your Microsoft 365 tenant. Always include the full customer name and, if possible, the customer’s domain name in the prompt. For example, “Use data from all emails and meetings where contoso.com appears.” If Copilot still returns generic text, provide a sample paragraph from a previous account plan and ask Copilot to match that style and level of detail.

Copilot cannot access CRM data

Copilot reads only data stored in Microsoft 365 services such as Exchange Online, SharePoint, OneDrive, and Teams. If your CRM data lives in Salesforce, HubSpot, or another external system, Copilot cannot read it unless you have synced that data to Microsoft Graph using a connector like Microsoft Data Connector for Salesforce. To check, go to the Microsoft 365 admin center, select Settings, then Org settings, and look for the Data connectors tab. If the connector is not set up, you must manually copy the relevant CRM fields into the account plan document.

The generated plan is too long or too short

Copilot does not have a word count target. To control length, specify the desired output in your prompt. For example, “Create a one-page executive summary of the account plan for Contoso. Use bullet points for each section and keep each bullet to one sentence.” If the output is too short, ask Copilot to expand specific sections. If it is too long, ask Copilot to condense it to a summary.

Copilot Prompt Structure for Account Plans: Basic vs Advanced

Item	Basic Prompt	Advanced Prompt
Scope	Creates a plan from all available data without filtering	Filters data by customer name, time range, and specific document sources
Output structure	Default sections chosen by Copilot	User-defined sections with explicit headings and order
Data sources	Emails and meetings only	Emails, meetings, SharePoint files, OneNote notebooks, and Teams chat
Example	“Create an account plan for Contoso”	“Create a sales account plan for Contoso using data from the last 90 days. Include sections for executive summary, customer business overview, key stakeholders, current challenges, our proposed solution, competitive landscape, sales strategy, and next steps. Use bullet points for the challenges section and a table for the competitive landscape. Pull stakeholder names from recent emails and meeting transcripts”

Copilot in Microsoft 365 can reduce the time to draft a sales account plan from hours to minutes. Start with a specific prompt that names the customer, the time frame, and the sections you need. Use Copilot in Outlook and Teams to gather supporting context from emails and meetings. Review every output for accuracy, and edit any placeholders or generic content before sharing the plan with your team. For your next account plan, try adding a prompt for a risk assessment section to identify potential deal blockers early.