Databases - Contacts vs. Spreadsheets

[Peter Brown]

I want to be able to sort my customers via the products they buy. I know how
to do an excel spreadsheet which is useful for mail merges. I also know that
by adding new categories you can sort contacts. Which is the best system?
Pros/cons of each method please

Peter

 

[Chris Schatte]

Peter,
Not an Excel method, but there is a built in report for this in Small
Business Accounting 2006:
http://office.microsoft.com/en-us/FX011956881033.aspx
Filter by class, item, date range, etc...
You can also export to Excel for further customization.

Chris Schatte
--
use the Office Online web based newsreader here:
http://www.microsoft.com/office/community/en-us/default.mspx
In Office System 2003 applications:
Help/Assistance Pane/Communities
SBA Spotlight

 

[Peter Brown]

Trouble is I don't have Small Business Accounting. Just trying to compare
the two programs/methods that I have

 

[Chris Schatte]

Peter,
You could also post in one of the Excel groups:
http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

Chris Schatte
--
use the Office Online web based newsreader here:
http://www.microsoft.com/office/community/en-us/default.mspx
In Office System 2003 applications:
Help/Assistance Pane/Communities
SBA Spotlight