Word Forms

B

Brad

I have several forms that are being used by multiple employee's. Currently
they are taking information from a sql database and entering them into these
forms. Is there a way to populate fields in the word doc by entering an
account number in the form? If not through word, does anyone know of another
microsoft program that can do this? Seems like there has to be considering
we are almost to 2010...
 
S

Susan Ramlet

You can learn Office automation and macros to do such a thing. I don't think
there's a quick answer that you'd get from the forums, because it's a bit
more complex than that...It's also hard to suggest a specific solution
without knowing more about your environment and requirements.

You might try posting to one of the macros or forums to learn more about how
to automate tasks using Office.

Office has had this capability for integration and automation for many
years; it's just a matter of learning how to program it (or hiring someone
who can).

Microsoft Access, the database program, itself has some nice forms
capability, so you might consider its feature set as it maps to your needs,
as well.

Here are some places to get more information:
http://msdn.microsoft.com/en-us/library/aa159896(office.11).aspx
http://word.mvps.org/FAQs/MacrosVBA/index.htm
 
Top