Hello all! With this real estate software I'm workin on, I need several macros to automate processes that need to be done. I need to be able to run these macros from the switchboard that I have. However, I'm not sure if using a macro would be able to accomplish this easily. Visual basic may be needed, but hopefully somebody can guide me. 
Here's the macros that I need and what they do:
- Add monthly rent to balance on 1st of every month AND reset the rent paid to 0.
- On the 6th day of every month, automatically post 5% of monthly rent to anybody that is past due and print late notices for ones that are late. I have set up a query for this and also created a word file that I want to do a merge with. I've put the fields from the query in the places I want along with any information that needs to be in there. However, I'm unclear on how to select only those that are late after the 6th of each month and how to create a macro to do the merge with Word and print the documents.
- On the 11th day of every month, automatically print inhouse eviction notice to all tenants that have yet to pay their rent. I've also created a Word document that basically tells the tenant if they don't pay they'll be evicted and I've created a query for this as well and put the proper fields in the Word document. Once again I'm unclear on how to select those that haven't paid their rent by the 11th of each month and how to do the merge with Word and print the documents.
- On the 16th day of every month, automatically print eviction proceeding letters which basically tells the tenant they will be evicted. Also automatically $75 to the tenants unpaid balance for court fees and filing fees. And once again, I'm unclear on how to select those that still haven't paid by the 16th and how to do the merge with word and print the documents.
These word documents are letters to each tenant that hasn't paid by a certain time. Each tenant that hasn't paid by a certain time gets a letter.
Any help you can give me is appreciated deeply!
Thanks!
David Somers
Here's the macros that I need and what they do:- Add monthly rent to balance on 1st of every month AND reset the rent paid to 0.
- On the 6th day of every month, automatically post 5% of monthly rent to anybody that is past due and print late notices for ones that are late. I have set up a query for this and also created a word file that I want to do a merge with. I've put the fields from the query in the places I want along with any information that needs to be in there. However, I'm unclear on how to select only those that are late after the 6th of each month and how to create a macro to do the merge with Word and print the documents.
- On the 11th day of every month, automatically print inhouse eviction notice to all tenants that have yet to pay their rent. I've also created a Word document that basically tells the tenant if they don't pay they'll be evicted and I've created a query for this as well and put the proper fields in the Word document. Once again I'm unclear on how to select those that haven't paid their rent by the 11th of each month and how to do the merge with Word and print the documents.
- On the 16th day of every month, automatically print eviction proceeding letters which basically tells the tenant they will be evicted. Also automatically $75 to the tenants unpaid balance for court fees and filing fees. And once again, I'm unclear on how to select those that still haven't paid by the 16th and how to do the merge with word and print the documents.
These word documents are letters to each tenant that hasn't paid by a certain time. Each tenant that hasn't paid by a certain time gets a letter.
Any help you can give me is appreciated deeply!
Thanks!
David Somers
