Automated Word Document Population from Excel
Budget: $30 – $250 USD
I need a system that can automate the data entry of Excel sheet information into a Word document ive attached the word doc template with the colomume names that data needs to com from. The process involves:
- Adding an MPRN before the number in the Excel cell.
- Adding GT1 at the end of the file name.
- Saving each populated form as a separate file.
The system should also:
- Send each form in a separate email.
- Determine the email recipient based on the postcode. For this, you will need to check the postcode on https://findmygdn.co.uk/ to ascertain the correct email to send the form to.
- Only include specific columns from the Excel sheet data in each email.
Ideal skills for this project include:
- Proficiency in VBA for Word and Excel
- Experience in automating data entry and document generation
- Knowledge of email automation and handling
- Familiarity with data manipulation in Excel, including adding specific content to cells
- Attention to detail to ensure the correct handling of multiple entries for the same postcode
- Adding an MPRN before the number in the Excel cell.
- Adding GT1 at the end of the file name.
- Saving each populated form as a separate file.
The system should also:
- Send each form in a separate email.
- Determine the email recipient based on the postcode. For this, you will need to check the postcode on https://findmygdn.co.uk/ to ascertain the correct email to send the form to.
- Only include specific columns from the Excel sheet data in each email.
Ideal skills for this project include:
- Proficiency in VBA for Word and Excel
- Experience in automating data entry and document generation
- Knowledge of email automation and handling
- Familiarity with data manipulation in Excel, including adding specific content to cells
- Attention to detail to ensure the correct handling of multiple entries for the same postcode