Hi, I' wondering if anybody can tell me if there is a way to automate a form based on the value of a form field. e.go. I have an Excel worksheet listing each recipients information that I want to insert in various field of a document based on their response to the first field (e.g. Name). Can VBA be written that will look at the field, and based on the text in the field, go to the Excel worksheet and retrieve the proper data? Thanks, Rich
Probably, but I suspect a mailmerge would be much easier. -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! My criminal defense site: http://addbalance.com --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Richard" wrote in message news:LIncg.19568$LE4.16531@tornado.tampabay.rr.com... > Hi, > > I' wondering if anybody can tell me if there is a way to automate a form > based on the value of a form field. e.go. I have an Excel worksheet > listing > each recipients information that I want to insert in various field of a > document based on their response to the first field (e.g. Name). Can VBA > be > written that will look at the field, and based on the text in the field, > go > to the Excel worksheet and retrieve the proper data? > > Thanks, > > Rich > >
