Reply to thread

Message: [QUOTE="Eechhutti R.Rajasekaran, post: 2544241"] Add one more field Customer Reply to enter the date of customer's reply. Generate a query with all the fields, giving the criteria under "1st Letter Sent" field to be Date()-7 and "Customer Reply" field to be Null. When you run the query, you will get the details of the customers to whom 1st letter has been sent 7 days back, but have not called on. Create a macro to run this query and name it as autoexec. In such a case, when you open the file, automatically you will get the particulars of such customers you have to contact. Eechhutti R.Rajasekaran rsrraja@hotmail [/QUOTE]