Dear All,
I'm looking to program some sort of code, VBA, to export data from access 2010 to a word 2010 document which in it self represents a form. Here is the catch.
In access i have a specified name referring to the word document form. For example i have lots of forms A, B, C etc. SO i select form B it ones up form B, i then have to manually fill the form out, however access already contains all the necessary information. I.E System name, Number, Equipment Number etc.
So the question is, is there a way to export all the data from access to the word document pre specified into correct columns and rows in the word document?
I was thinking of using idetifiers such as: if line contains System ID: place space nad insert from System ID.
Could you at least point me in the right direction or provide a solution for me?
I know this is very poorly worded but my knowledge in access is very poor. Any help would be highly appreciated.