Merging Access data to Word doc

B

Brown

I am running Office XP, Pro including Word and Access.

I am trying to take fields from an Access query and post them into merge
fields in a Word doc.
There will be one record in the query with numerous fields, most fields are
basically paragraphs of text for the doc, some of the fields will populate
tables in the word doc.

Is there a reference or KB that discusses how to do this?

TNX

Brown
 
P

Peter Jamieson

Is there a reference or KB that discusses how to do this?

At face value what you are describing is a standard merge - you create your
document, you select the data source (your Access query), you insert Merge
fields into the document where you want the results to appear, you perform
the merge.

However, there are plenty of things that /might not/ work as you expect,
e.g. you might not be able to see your query in the list of queries when you
select your data source, if you are getting long text data or rich text data
it may not work as you expect, etc. Or it may be that you want to merge
multiple records (despite the "one record in the query" comment in your
message) into a single document or table.

So maybe you could be a bit more precise about what you want to achieve,
what problems you are encountering, etc.?
 

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