Command Button to Mail Merge the Form's Data

[Wade]

This may be stretching my limited experience with Access.

Good Morning.

I would like to put a command button on a form and have it
send that record's information to a Mail Merge Word
document.

I already have the Mail Merge Word document created, and
it works fine, but I have to select what record to use
after I open Word separately.

Is there a way to get the form to open the specific Word
document I need and put the record's data into the Merge
cells in Word? I only want that one record sent.

I have VERY limited experience with VB. I know just
enough to get me frustrated and confused.

 

[Byron]

Wade,

Take a look at a recent posting by Albert D. Kallal. I
found it to provide just what I needed and perhaps you
will also.

I have copied his response below:

I have a nice working sample of how to do a word merge
from a
ms-access form. You should likely give my sample a try
(as it is ready to
go..and is DESIGNED to be used with your application). It
is bug proof
also..and even works if you are using a secured ms-access
file. Check it out
at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.htm
l

--
Albert D. Kallal (Access MVP)


HTH

Byron

 

[Guest]

This didn't work.

I tried several techniques and even pasted all the
contents of the example database into my new current
database.

When I click on the Word button, I get a compile error and
a section of the code higlighted that states

Dim OneField As DAO.Field

It runs fine in it's own database, but for some reason it
won't run in mine.

 

[Adrian Jansen]

Open a code window and look in Tools|References. Check the box alongside
DAO (version xx) Object Library.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control