Show All

Hide All

In Business Contact Manager for Outlook, you can filter the information provided in the standard reports to produce only the information you want to use. For example, by using the Simple Filter (filter: A filter can define which records or columns are returned from a query. A filter always limits the outcome.) you can refine the standard report named Accounts by city to show only Accounts that are Active and have a rating of Excellent.

You can further refine your reports by using the Advanced Filter to combine multiple field values into comparative expressions that produce a single result. For example, if you want to send congratulatory greetings to all of your Active Business Contacts whose anniversaries or birthdays occur in the next 60 days, you can create the following query, using parentheses to group the values: Active = Is Selected And (Anniversary = Next 60 days Or Birthday = Next 60 days).

 Tip   Use the Advanced Filter to filter on your user-defined or customized field names. For information about customization, see Customize your Business Contact Manager forms through user-defined fields.

You can also use the filters when creating a Marketing Campaign (Marketing Campaign: A marketing program that uses many communication vehicles, for example, ads and direct mail, to accomplish a specific result, such as increasing marketing share, introducing new products, or retaining customers.) to further refine who receives the campaign in your list of Business Contacts (Business Contact: A person with whom you do business at a company or organization.) or leads (lead: A potential customer who must be contacted by a salesperson and either qualified or disqualified as a sales opportunity.). For more information about creating a Marketing Campaign, see Promote your business with Marketing Campaigns in Business Contact Manager.

Filter a report

1. Open a new or saved report.

2. Click OK to display the results in the report.
3. Click the Review Results tab to view the information that will be displayed in the report. For more information, see Review Results in Filter Records for Business Contact Manager.

4. Do one of the following:

   • In the Filter dialog box, click the Open Filter button to select and use a saved filter.
   • In the Filter dialog box, on the Simple Filter tab, select or clear the options that you want. For more information, see Simple Filter in Filter Records for Business Contact Manager.
5. If you want to refine the report results by specifying additional criteria, click the Advanced Filter tab, and then specify the information you want to filter. For more information, see Advanced Filter in Filter Records for Business Contact Manager.
6. In the report, on the Reports toolbar (Reports toolbar: The toolbar at the top of the Reports section, used to create and edit reports.), click the Filter Report button.
7. On the Reports toolbar, click the Save Report button to save the report.

    Note   By default, a report is saved in the Business Contact Manager report (.bcr) file format. To create a report that you can use in other file formats, export the report to Microsoft Office Excel*, and then copy or save the report to the file format that you want.

8. To save the filter to reuse it, in the Filter dialog box, click the Save Filter button.

Other actions

Print a report

To print a report, do one of the following:
• On the File menu, click Print.
• On the Reports toolbar, click the Print   button.

Send an e-mail message with the report as an Excel* attachment

To send an e-mail message with the report as an Excel* attachment, do one of the following:
• On the File menu, click Send E-mail with Excel* Attachment.
• On the Reports toolbar, click the Send E-mail with report as Excel* Attachment   button.

Export the report to Excel*

To export the report to Excel*, do one of the following:
• On the File menu, click Export to Excel, and then, in Excel*, save the report in the file format that you want.
• On the Reports toolbar, click the Export to Excel   button, and then, in Excel*, save the report in the file format that you want.

Modify the report by using the Modify Report pane options

To modify the report by using the Modify Report pane options, do one of the following:
• On the View menu, click Modify Report Pane.
• On the Reports toolbar, click the Modify Report   button.
For more information, see Help with modifying a Business Contact Manager report.

Other ways of accessing the filters

*The stand-alone edition of Microsoft Office Outlook 2007 with Business Contact Manager can be used with Excel 2007 or Excel 2003.