How do I talk directly to WORD Objects from Access

B

Brian76239

I want to merge a word document and a table from Access without
doing all the mouse click stuff. I know I can talk directly to objects in
WORD. How do I find what objects are available?

Probably a dumb newbie question. I am definitely stuck and need HELP!
 
E

ErezM via AccessMonster.com

hi
add a reference to microsoft word in tools...references in vba's ide window
then open the object explorer and search through
many times when i'm not sure how to automate something in word or excel (from
access), i open word and record a macro doing all the stuff i want, then copy
the code to access vba and use it
be aware that it will always nedd some degree of changes to work from access
(starting with the reference and creating the object) but it shortcuts most
of the way

good luck
Erez
 
P

Piet Linden

I want to merge a word document and a table from Access without
doing all the mouse click stuff. I know I can talk directly to objects in
WORD. How do I find what objects are available?

Probably a dumb newbie question. I am definitely stuck and need HELP!

Albert Kallal's Super Easy Word merge?
 
A

Albert D. Kallal

Brian76239 said:
I want to merge a word document and a table from Access without
doing all the mouse click stuff. I know I can talk directly to objects in
WORD. How do I find what objects are available?

Probably a dumb newbie question. I am definitely stuck and need HELP!

I have a nice working sample that does a merge of the current record to
word.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the following page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top