Hi All,

I am looking for some example code from someone who has done this kind of thing before using Office 2002 apps.

Basically I want to create a form in Word that has inserted data fields (can do that)which can be emailed to users to fill in information. The fields could be numeric, date or text.

Completed form then emailed back to me.

Then want some code to take info. entered in the word form and transfer this to table in access

Not sure whether the best approach is to associate the VBA "transfer" code with the access database or with a "Save Button" macro on the Word form (ie push or pull the information across?)

If anyone has some code snipetts they can post to give me a start that would be great

As far as whether you want to push the data out of Word or pull the data from Access, it depends on the relability of your staff. Consider this... the Word document is going to go out to all staff. The locations of each copy of the document will be in countless directories on a large number of machines.

If Access is to pull the data, it will have to know where to pull from. If that's the case, all staff will have to place their final copy of the Word document on a shared drive so that Access will know where to look for it. You will have to rely on staff to remember to do that when they're ready.

If you make Word push the data, I'm assuming the one and only Access database resides in one place. Therefore each Word macro will be pushing to the same place. It doesn't matter where the Word document is pushing from. This make it easier. You will have to rely on staff to remember to push the data.

Either way, you must get staff to remember to do a final action. To me, the easiest is to get staff to push a button rather than to copy a file to some directory. Therefore, my vote is to have Word push the data because it's easier to have Word documents located everywhere push to one spot.

For code snippets, I have code from a Word macro that pulls from Access but not that pushes to it. Still interested? If so, send me a private message with your e-mail address.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division