Google Spreadsheets / Excel formatting and text generation for emailing
I require someone who has great skills in either:
Google apps script to create formulas/macros to do the task below (Preferable). Or formula and macro creation on Microsoft Excel (advanced level only). Good English is must.
I work in the property business and I advertise rooms on the internet on www.sparerooms.co.uk. People reply to my advertising saying that they would like to view my properties as they may wish to rent the rooms.
I have made an excel sheet to capture the information of the people enquiring for rooms. This is so I can message them in the future for other rooms that come available. I will be capturing information such as their name, age, desired living location, budget, single/double room and etc. This information will have to be manually entered, please see ‘S2 - Tenants’ sheet on the spreadsheet here:
This data is mostly gathered via the user’s profile or through the message they send on Spareroom.co.uk when asking for a room.
Some of the data fields that I require will not be in either the profile nor the initial message. Therefore, I would like a macro/function of some sort to generate a template email letter response asking for details that are yet to be obtained.
Task 1 - Spreadsheets format setup:
The successful applicant will need to ensure all 29 columns have the required format. The various column formats can be found in the file attached.
Task 2 - Email text generation:
The successful applicant will need to create a macro/function (or something simple) that enables the easy generation of text. This text will include specific questions if there shown if specific blank fields are present in that persons row. I will then be able to paste this text into an email asking for the missing data. There is more detail and example in the attached document.
Please respond to this advert detailing how you complete the task including if it will be on google spreadsheet or excel spreadsheet. Also, please say what you think is the best way to generate specific text based on missing data. Please only respond if you have good English skills please.