We are a landlord looking to automate and improve our administrative process of notifying tenants who do not pay their rent.
Currently, our account department's system will produces an excel sheet called the statement of accounts (screenshot attached). It is then printed out and handed to an employee in the legal department which has to manually key in the details from the statement of accounts to create the letter of demand which is sent to tenants. This process is time consuming and can be automated through VBA. Unfortunately, a simple mail merge will not work as the system generates new excel sheets for each tenant
Essentially, we need to create a mail merge, but with dynamically adjusting fields within the excel sheet, as different tenants owe various amounts.
Screenshots of both the Letter of Demand (highlighted fields indicate which need to be manually updated) and Statement of accounts have been included.
35 freelancere byder i gennemsnit $164 på dette job
Hi I read your description and saw your attachment. I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. I am sure i can handle your request
Working with a mnc compnay.. having 12 years of experience in Excel & VBA... If i will get this project will help you for any further changes also.