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 VBA code to take info. entered in the word form fields and transfer this into a 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
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 VBA code to take info. entered in the word form fields and transfer this into a 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