I have an annoying problem which I have to sort out. I have been asked by the company director to create a new way of generating invoices.
Creating them could be done very easily and efficiently by trasnfering data to Excel, which I have already produced. But the managing director wants me to produce exactly the same thing in word, because the old system which is in place was produced manaually by a member of the administration team often creating errors along the way.
I have made the Excel spreadsheet look identical (in my eyes) to the old word invoices.
Sorry about all of the waffle.
Here's the question:
Is there a way of moving data from access to word position in the correct way do all of the formating for fonts layout etc using VB?
I have considered creating a separate temp table then using a mail merge to get the information to the word document but I see this as over the top as many users will not like to do that, and I believe that staff will begin to revert back to the old system which is not what I want.
Creating them could be done very easily and efficiently by trasnfering data to Excel, which I have already produced. But the managing director wants me to produce exactly the same thing in word, because the old system which is in place was produced manaually by a member of the administration team often creating errors along the way.
I have made the Excel spreadsheet look identical (in my eyes) to the old word invoices.
Sorry about all of the waffle.
Here's the question:
Is there a way of moving data from access to word position in the correct way do all of the formating for fonts layout etc using VB?
I have considered creating a separate temp table then using a mail merge to get the information to the word document but I see this as over the top as many users will not like to do that, and I believe that staff will begin to revert back to the old system which is not what I want.
