Access to Word Form Fill

the undefy

New member
Local time
Today, 11:56
Joined
Jul 24, 2009
Messages
4
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.
 
If you place in BookMarks in the Word Documents you can then use the Goto Bookmark command and then it can place in the relevant data.

Will you be running this process from an Access form with the current data being shown?

Also have you considered Mail Merge.
 

Users who are viewing this thread

Back
Top Bottom