Merging to word

[Khartoum]

Hope somebody can advise - i have a form for managers to record sickness
absences - is there a way that once certain fields on the form are complete
that i can click a button which will make them merge into a stored word
document so when they open that document that information transfers to it -
unfortunately the word doc is in a single location and universally accessed
by people not using a database therefore it is difficult for me to name the
fields on the word doc and do via mail merge
thanks Kh.

 

[Stockwell43]

Hi Kh,

Just curious, why do you want to enter Sickness and Absent information into
a database and then merge it into a word document? Is the word document a
letter you are sending out to the employee? You were not really specific as
to why you wanted to accomplish this becuase you go on to say that others
have access to the document. If you are looking to merge to keep a record,
you could just pull a report from Access. Please give a little more detail.

Thanks!!

 

[Khartoum]

It is a standard form across a huge sector - the database is used only by a
part of that sector. Other areas have their own systems of monitoring absence

 

[Larry Daugherty]

You can do what you need to do by using Automation from Access. Look
in Help for "Automation". There isn't much there but it really is
enough to get you started. Many people find it insufficient but
that's because it assumes that the reader is a competent coder in VBA
and in both the client and server platforms.

I suggest that you start your coding effort in Word. You need to
create VBA code to open the target document (gracefully failing if the
document can't be opened at the moment). When the document opens,
navigate to the proper place within it and write the contents of a
couple of variables in your local code to the foreign document. When
all of the code works as you'd like then move it over to Access and
build the Access code around it.

The one million and one details omitted above are dependent on your
situation and the strategies you choose.

HTH