I have reposted this project in order to provide more details regarding my requirements.
I am looking at combining 2 different sets of excel data to create 1 invoice/packing list in word which can then be printed 1 order per page on company letterhead.
one excel file will have order number, name address etc.
the second excel file will have order number, details of items ordered etc
this information is provided to me in the form of a csv from my on line store.
all i require is either a simple file/system that will enable me to upload this information and sort/layout the final word document to my requirements. i am not looking for someone to enter this on a daily basis.
it would need to have the facility to recognise the info from both files using the order number and pull respective information together.
if there is 1 buyer for instance it would need to show products ordered on multiple lines, not multiple pages.
each order is to be printed on new page on company letterhead.
i have 2 csv files as samples to provide if you wish so you can show me how this is done.