Data dB from table over wordtemplate
Budget: £10 – £15 GBP
How to get data from db table over to a Wordtemplate in an more easy way
(This description below is also in Word doc in attachment with image of work progress)
We have today 15 different design templates (in Word) where customer can choose what design they want to their CV.
Customer, or we in admin use a form on our webpage where we add all information of a customer.
This is stored in two db tables. Customer info and work/education++ info.
When we in admin are going to create the CV for customer with a of of the 15 design we do as follow:
In local computer we have an Excel document.
This Excel document is in a folder with all the 15 templates word document we have.
We start the excel sheet and click on a macro: Get data
This macro get data from our webserver. It is a visual basic script in the excel that get data.
All data came into the excel sheet.
We mark the customer we need to have a new design on (type print outside customer). Then we save the excel sheet.
Then we choose from the folder what template we want: One of the 15.
Inside the Word template we click on a macro who start a visual basic script and fill inn all data:
This is a little big prosess. Can it be done in a more easy way?
We must get it out in a Word document and then small, small edit before we send it to customer.
We can change our db structure if necessary.
Solution:
The best way would be to could sit on computer. Be inside admin where the order from customer is.
Then click on a button that download, fixing local word template and be finish ;-)
(This description below is also in Word doc in attachment with image of work progress)
We have today 15 different design templates (in Word) where customer can choose what design they want to their CV.
Customer, or we in admin use a form on our webpage where we add all information of a customer.
This is stored in two db tables. Customer info and work/education++ info.
When we in admin are going to create the CV for customer with a of of the 15 design we do as follow:
In local computer we have an Excel document.
This Excel document is in a folder with all the 15 templates word document we have.
We start the excel sheet and click on a macro: Get data
This macro get data from our webserver. It is a visual basic script in the excel that get data.
All data came into the excel sheet.
We mark the customer we need to have a new design on (type print outside customer). Then we save the excel sheet.
Then we choose from the folder what template we want: One of the 15.
Inside the Word template we click on a macro who start a visual basic script and fill inn all data:
This is a little big prosess. Can it be done in a more easy way?
We must get it out in a Word document and then small, small edit before we send it to customer.
We can change our db structure if necessary.
Solution:
The best way would be to could sit on computer. Be inside admin where the order from customer is.
Then click on a button that download, fixing local word template and be finish ;-)