MacDermott
I'd suggest this:
First, from Word:
Create a template in Word (not a mailmerge).
Put a bookmark in it where you want to do your insert.
Save this template.
Now, from Access:
Create a recordset based on your query.
Open a Word document based on the template.
Navigate to the bookmark.
Loop through the recordset, inserting the data into your Word document.
Save the Word document, and quit Word.
Close your recordset.
HTH
"joeygun" <joe.egan@comcast.net> wrote in message
news:1114308820.477504.123150@z14g2000cwz.googlegr oups.com...[color=blue]
> I'm trying to do something I thought would be easy, and maybe it is,
> but I've spent the afternoon now reading about bookmarks, templates,
> Word mail merge, VBA, automation and am seemingly no farther along than
> I was when I started.
>
> All I want to do is link a dozen or so records (data type memo) from a
> query containing a single field into a single Word document, one right
> after the other. The only other requirement is that I don't want them
> in a table, which seems to be the part I get hung up on. I'm using
> Word/Access 2002.
>[/color] |