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.
34 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
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
Hello friend, I was analyzing your problem and I know how to help you. With a vba form it is possible to do what you need. I await your confirmation to start. Greetings.
I'm very good with Excel and Word. Even I can write macros for automatically input the data. Now I'm working with big databases and transform them to extract meaning data.