View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge Access form/subform fields into Word 2007 document?

You may find Albert Kallal's macros at

http://www.members.shaw.ca/AlbertKal.../msaccess.html

do something useful in this area.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Peter Jamieson" wrote in message
...
Word really works with the underlying data rather than the data sitting on
a particular form (although an Access SQL query can reference "Form"
fields, not just "database" fields, if you issue such a query from Word
you have to be connected to Access using DDE and I don't think you can
rely on the results.

Your best best is probably to put a button on your form that saves the
data, or references to the data in a format that Word can use - for
example, you might export the referenced record(s) to a delimited text
file, or save it/them in a special table in the database, or save the
record number in a special table, etc.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"denilynn" wrote in message
...
Is it possible to merge Access 2007 form and subform fields into a Word
2007
document?
--
Thanks in advance for your time!
denilynn