Table of contents
Grow your business
Grow your business

Manage leads and sales

Track your sales contacts with these templates, use Microsoft apps to track new customer information, and manage emails from your customers in Microsoft Outlook.


Use these templates to make and track your sales. Start with our basic templates, and then update them as needed for your specific business.

Use Microsoft Forms and Microsoft Power Automate to automatically track potential customers

Say you're sending out a new marketing campaign and want to collect data about potential customers. Or you want to capture customer information at an event. You can use Microsoft Forms to collect the data, and the route the data with Power Automate to a SharePoint list and an email address so you can follow up appropriately.

This video walks you through the process:

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.
  1. First, create a list in SharePoint to track potential customers and their basic information: name, company, phone, address, and so on.

  2. Next, Create a form in Microsoft Forms to gather that customer information - use the same fields and the same data types as in your SharePoint list.

    You can include a link to the form in an email or document or embed it in your website.

  3. Then, Create a flow in Microsoft Power Automate to capture any responses to your form in your SharePoint list.

    Start with the Record form responses in SharePoint template and customize it. You'll need to know:

    • The ID for the form where you're capturing the data.

    • The ID for the SharePoint list into which you want to put the data.

    • The fields you want to map between the form and the list.

  4. Finally, add an action to the flow to send an email through Outlook and Microsoft 365 to the appropriate person for follow up. You'll need to have the group or individual email address to which you want to send the information.

Use Outlook to manage customer emails

Put all of your customer emails into one place so you can find them quickly, and see when you need to follow up.

  1. Create a folder for your customer in your Inbox.

  2. Set up a rule to move email from your customer to your folder. For example, create a rule with the following conditions to automatically move emails from a particular customer to a particular folder:

    • Apply this rule after the message arrives

    • from <customer email address>

    • move to the <customer folder>

Related resources

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!