Office Automation Problem

[DBrandy]

I have multiple documents that I have to hand type out. Each time I generate a document I have to change the company name, ID number, and a dollar amount, that I have to calculate in excel. Everything else in the document is pretty much boilerplate.



What I'm interested in doing is setting up an Access database that will lookup the company name and ID number from an Oracle database, Plus this information into a form to perform the calculation and automatically generate a report with this information. The reason being is I'm trying to improve typo errors that are made after doing several hundred of these in a day. Any thoughts?

Is this possible in Access?

[June7]

Certainly should be possible. Have to connect Access to the data for starters review http://www.emunix.emich.edu/~khailan..._to_oracle.htm

[DBrandy]

Certainly should be possible. Have to connect Access to the data for starters review http://www.emunix.emich.edu/~khailan..._to_oracle.htm

Thanks very much for your assistance. I greatly appreciate your help.