Using Word to get data?

[Linn Kubler]

Hi,

We are using Office 2003 Standard and have a database application, which
uses SQL Server 2000 as a backend. One of my users needs to print envelopes
occasionally and the recipeint is in the database. What I'd like to do is
show her how she can look up a specific recipient in SQL and be able to
print an envelope.

What I'm envisioning is having the user go through this process:
Open Word
Open template (or some other mechanism)
Some how enter the recipient's name, perform a search and print an envelope
from the results.

I'm guessing this is possible through macros or something but not sure how
to get started.

Does this make sense?
Can it be done?
Can someone get me started or show me examples of how this could be
accomplished?

Thanks in advance,
Linn

 

[Doug Robbins - Word MVP]

See the article "Access a database and insert into a Word document the data
that you find there" at:

http://www.word.mvps.org/FAQs/InterDev/GetDataFromDB.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[alborg]

A really cool tutorial can also be found here-
http://www.fontstuff.com/vba/vbatut10.htm

An "open source" state list applet that shows how to "pull" state name
infomation in various ways can be found here:
http://www.box.net/shared/static/wu2pcxt0kk.zip

Cheers,
Al