Several readers had essentially the same question last week:
I want my users to enter data into a form, then take that information and put it into a form letter.
There are two tutorials on the site that cover much of the same information about how to do this. Both are based on Office 2000 rather than the latest Office 2003 which incorporates the new VB.NET VSTO (Visual Studio Tools for Office) technology.
The first tutorial is VB Programming for Non-Programmers! Because Word VBA is a handy environment that a lot of non-programmers already have available to them, this tutorial is based on it. Starting in a true "from the ground up" philosophy, the tutorial covers recording a Word macro, running, changing, and finally creating a new macro within the VBA editor using form components in Word. An introduction to Word objects, methods, and properties is also part of the tutorial. The tutorial consists of four lessons delivered one per week to your email inbox.
The second is VBA - The Visual Basic Working Partner. This intermediate level tutorial covers some of the same ground as the beginning course, but the focus here is using VBA across the Office applications with special emphasis on VBA for Word, VBA for Excel, and VBA for Access. This tutorial is packaged ih five weekly email delivered installments.
To cover VSTO, we have the lesson for Chapter 13 from the tutorial: Microsoft Visual Basic .NET - The Complete Course. This chapter is primarily about VSTO so it pretty much "stands on it's own" if you want an introduction to that technology. You can dip into the middle of the "Complete Course" and read just this lesson about VSTO by clicking here.
While we're on the subject of reader questions, however, I'd like to make an appeal to everyone who takes the trouble to write to me:
Please include the details I need to help answer your question!
When I receive a question, the first thing I usually have to do is search the About Visual Basic site to attempt (it isn't always possible) to figure out which article or tutorial the reader is talking about. If you have a question based on something on the site, please give me the web address so I can go directly to the right one.
And include actual code to illustrate your question! I can't tell you how often I receive a question like, "I tried to do your example, but it didn't work for me! Why not?"
Some questions I might have include:
* - Which example?
* - What didn't work?
* - Was there an error message or just an unexpected result?
* - What version of software - such as the version of Visual Basic, Office, or Windows - are you running?
Remember, the more information I have, the more likely I am to be able to actually provide some useful information back to you! Thanks - in advance - for your help and understanding!