<WBR>Michelle<br>
<br>
I don't know of any systems out there, but I set up my own database in which I include a last tuning month and a next tuning month. The next one might be 3 months, 6 months or a year from the last service month, but the last service month stays the same until i tune the piano again. When I send out reminder notices, I first look for the "next tuning date" customers, and then the "last tuning date" customers. I send out reminder notices for 4 years. <br>
<br>
<div style="CLEAR: both">Willem (Wim) Blees, RPT<br>
Piano Tuner/Technician<br>
Honolulu, HI<br>
Author of <br>
The Business of Piano Tuning<br>
available from Potter Press<br>
www.pianotuning.com</div>
<br>
<br>
-----Original Message-----<br>
From: Michelle Smith <michelle@smithpianoservice.com><br>
To: 'Pianotech List' <pianotech@ptg.org><br>
Sent: Sat, 12 Apr 2008 3:01 am<br>
Subject: Customer Database<br>
<br>
<div id=AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642>
<STYLE> @#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}@#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 font-face {font-family:"Comic Sans MS"; panose-1:3 15 7 2 3 3 2 2 2 4;} #AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 p.MsoNormal,#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 li.MsoNormal,#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif";}#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 a:link,#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;}#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 a:visited,#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;}#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri","sans-serif"; color:windowtext;}#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 .MsoChpDefault {mso-style-type:export-only;}@#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;}#AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 div.Section1 {page:Section1;}</STYLE>
<div class=Section1>
<div 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. </div>
<div class=MsoNormal> </div>
<div class=MsoNormal>In addition to this, we’re working on a feature that would automatically send e-mail reminders to customers. </div>
<div class=MsoNormal> </div>
<div 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. </div>
<div class=MsoNormal> </div>
<div class=MsoNormal>Has anyone seen a piece of software like this? I don’t want to reinvent the wheel. </div>
<div class=MsoNormal> </div>
<div class=MsoNormal><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Michelle Smith</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Smith Piano Service</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-SIZE: 12pt; COLOR: black; FONT-FAMILY: 'Comic Sans MS'">Bastrop, Texas</SPAN></div>
<div class=MsoNormal><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"> </SPAN></div>
<div class=MsoNormal><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman','serif'"> </SPAN></div>
<div class=MsoNormal> </div>
</div>
</div>
<!-- end of AOLMsgPart_2_3eed52b6-2ce9-4d72-86b1-b26ac7c58642 --><div id='u8CA6B357770019D-1020-6C7F' class='aol_ad_footer'><FONT style="color: black; font: normal 10pt ARIAL, SAN-SERIF;"><HR style="MARGIN-TOP: 10px">Get the <A title="http://www.mapquest.com/toolbar?NCID=mpqmap00030000000003" href="http://www.mapquest.com/toolbar?NCID=mpqmap00030000000003" target="_blank">MapQuest Toolbar</A>, Maps, Traffic, Directions & More!</FONT> </div>