views:

16

answers:

0

Currently, I'm using Excel 2002 with a ODBC connection to query an Oracle DB by User ID # and to return a set of parameters such as Name, Address, etc. to fill a mail merge form in Word 2003. I wanted to know where I could automate this process to the point that I would open up Word, be prompted for the User ID and being able to have the mail merge self populate. It seems like this is a simple script but I'm really new to VBA. Thanks!