Please Help

  • Thread starter Thread starter Eamon Straughn
  • Start date Start date
E

Eamon Straughn

i am trying to mail merge the data from a ms access report to a template in
ms word so that the end user can make any final ajustments if needed be. Can
some please give me a code VB so i can execute it via code not using the
publish word from the print view of the report.

Any suggestions will be welcomed and please can anyone tell me how because i
am a vb developer but not vb6 dont know where to begin there, tried
seraching for the objects but no ms word is accessible in ms access or you
cant import it like u do in vb.net can someone help

Thank you eamon
 
Eamon,

In your code module, you can set a reference (under Tools|References
menu) to the Woord object library, which would llow you to use Office
automation code to put data into your Word document. As far as I
understand you, it would not really be relevant to do this based on a
report... you re more likely to be using the data from a query, or a
recordset object. Anyway, this is a macros newsgroup, and your question
is not really relevant to macros. You are more likely to get a
comprehensive answer if you post to the
microsoft.public.access.externaldata or the
microsoft.public.access.modulesdoavba newsgroup.
 
Back
Top