* In a message originally to Frank Del Papa, Bill Patterson writes:

 FDP> Yes Bill, I mean mail merges for recall memos for specific customers.
 FDP> i.e. Merges which would allow me to recall customers by specific dates,
 FDP> or other specific ways.
 FDP> In our business, we keep track of all important customer related
 FDP> information such as their names, and adresses and whether the customer
 FDP> is french or english so that in the merges we  can actually select
 FDP> whether the merge is done in french or in english. We are in the
 FDP> automobile service. Specifically we are a Rust Check Rustproofing
 FDP> company. We specifically access a particular customer normally by typing
 FDP> in his car license plate number as the first item on an invoice, if the
 FDP> customer or of course vehicle exists in the database, then the old
 FDP> information reappears on our screen, with of course the last date of
 FDP> rust prevention visit. If the information is correct we preceed to
 FDP> making a new invoice and all information is updated.
 FDP> The pertinent fields are:
 FDP> the customer's name, address, city, postal-code, for the customer
 FDP> database and for the invoice database, the license-plate, serial number,
 FDP> make of car, model, year,.
 FDP> Our program is set up like this:
 FDP> License_plate :
 FDP> Serial_number :
 FDP> Car/Truck : (defaults on car unless we change it)
 FDP> Make :
 FDP> Model :
 FDP> Year:
 FDP> Last_name :
 FDP> First_name :
 FDP> Address :
 FDP> City : (defaults to a specific region unless we change it )
 FDP> Province : (defaults to a specific region unless we change it )
 FDP> French/English : (defaults to french unless we change it )
 FDP> Comments : Not included, but should work such that we are able to attach
 FDP> comments about the specific customer or about the vehicle.
 FDP> 
 FDP> Then we proceed to the invoice database which includes a list of
 FDP> services from pull down menus. From there we select the services, such
 FDP> as one Rust Check treatment or a motor wash or a polishing etc.
 FDP> 
 FDP> The taxes such as GST and QST ( that is federal and provincial taxes are
 FDP> automatically calculated and the invoice is ready.
 FDP> 
 FDP> The other important factor now is the payment mode, such as cash,
 FDP> master_card, visa or interact direct payment or by a split payment,
 FDP> (i.e. partly cash and visa or etc.)
 FDP> 
 FDP> And finally the marketing aspects.
 FDP> Where did this customer come from?
 FDP> Was it local papers, radio announcements, flyer distribution etc.
 FDP> 
 FDP> In this way we would be able to do statistical analysis of our
 FDP> advertising.
 FDP> 
 FDP> I hope this is a little help in determining the kind of repetitive work
 FDP> we perform.
 FDP> 
 FDP> While this kind of work is taking place I am curious to know if I am
 FDP> able through IBM CONNECT and another PC, to access the same program
 FDP> through a different post.?
 FDP> 
 FDP> Frank Del Papa
 FDP> 
 FDP> 
 FDP> --- Squish/386 v1.11
That sounds like a big job. What I'm working on right now will duplicate
alot of what you want. Do you have an Email address where I can send you a
note if I get anything worth while? Can you ftp examples and beta's from
me? Do you have a time limit?

Bill 


--- LoraBBS-OS/2 v2.40+