<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR>
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Comic Sans MS;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-compose
}
.MsoChpDefault {
mso-style-type: export-only
}
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 lang=EN-US vLink=purple link=blue bgColor=#ffffff>
<DIV><FONT face=Arial>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
<EM><STRONG>this information syncs with my PDA</STRONG></EM>. 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.</FONT></DIV>
<DIV><FONT face=Arial></FONT> </DIV>
<DIV><FONT face=Arial>Al Guecia</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=michelle@smithpianoservice.com
href="mailto:michelle@smithpianoservice.com">Michelle Smith</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=pianotech@ptg.org
href="mailto:pianotech@ptg.org">'Pianotech List'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, April 12, 2008 9:01
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Customer Database</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal>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><o:p> </o:p></P>
<P class=MsoNormal>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><o:p> </o:p></P>
<P class=MsoNormal>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><o:p> </o:p></P>
<P class=MsoNormal>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><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Michelle
Smith<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Smith
Piano Service<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Bastrop,
Texas<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BLOCKQUOTE></BODY></HTML>