<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:"Comic Sans MS";
        panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Al,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'> I sure would
love more details on how you do all of this.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal><span style='color:#1F497D'>Greg Newell<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Greg's Piano Forté<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>www.gregspianoforte.com<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>216-226-3791 (office)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>216-470-8634 (mobile)<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> pianotech-bounces@ptg.org
[mailto:pianotech-bounces@ptg.org] <b>On Behalf Of </b>AlliedPianoCraft<br>
<b>Sent:</b> Saturday, April 12, 2008 10:19 AM<br>
<b>To:</b> Pianotech List<br>
<b>Subject:</b> Re: Customer Database<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<div>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Arial","sans-serif"'>Michelle, I have been using Outlook for all
my customer information. I set up a date when the piano should be tuned again
and it reminds me when the date comes up. Each time I tune the piano I put in
the new due date. It also keeps all my tuning records, quotes, temp &
humidity etc. All <strong><i><span style='font-family:"Arial","sans-serif"'>this
information syncs with my PDA</span></i></strong>. You can use it to send your
email also. It also has a great lookup feature. Last week a customer
calls using a different name. (Her granddaughter had called originally.) She
said she wanted to go ahead with the work I had quoted her. I couldn't find the
record, but she gave me her address. I did a lookup with the street and her
record came right up. Works great for me. I keep all my income information in
Quickbooks.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Arial","sans-serif"'>Al Guecia</span><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<blockquote style='border:none;border-left:solid black 1.5pt;padding:0in 0in 0in 4.0pt;
margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'>
<div>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>----- Original Message ----- <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in;background:#E4E4E4'><b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'> <a
href="mailto:michelle@smithpianoservice.com"
title="michelle@smithpianoservice.com">Michelle Smith</a> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>To:</span></b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'> <a href="mailto:pianotech@ptg.org"
title="pianotech@ptg.org">'Pianotech List'</a> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>Sent:</span></b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'> Saturday, April 12, 2008 9:01 AM<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif"'>Subject:</span></b><span style='font-size:
10.0pt;font-family:"Arial","sans-serif"'> Customer Database<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal style='margin-left:.5in'>Hi guys. I’ve been
talking to my brother-in-law (who is a programmer) about creating a customer
database for my business. It would of course have all the usual fields
concerning customer information, piano information and date the piano was last
tuned. The thing I’m really wanting that I haven’t seen in
other software programs is for it to send me reminders based on when the piano
was last tuned instead of when it should have been tuned. For example, I
have a customer set up for reminders every 6 months. If they wait a
couple of months to have their piano tuned, I want the program to automatically
shift future reminders based on their most recent tuning date. <o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>In addition to this, we’re
working on a feature that would automatically send e-mail reminders to
customers. <o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>This information would hopefully be
transferrable to a spreadsheet on my PocketPC then I could also conceivably
enter the info at the customer’s home and then sync it with the main
database when I get home. <o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'>Has anyone seen a piece of software
like this? I don’t want to reinvent the wheel. <o:p></o:p></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Comic Sans MS";color:black'>Michelle Smith<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Comic Sans MS";color:black'>Smith Piano Service<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Comic Sans MS";color:black'>Bastrop, Texas<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><span style='font-size:12.0pt;
font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='margin-left:.5in'><o:p> </o:p></p>
</blockquote>
</div>
</body>
</html>