363,927 Members | 2749 Browsing Online
Community for Developers & IT Professionals
Bytes IT Community

Access query records to Word

joeygun
P: n/a
joeygun
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


MacDermott
P: n/a
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]


Nov 13 '05 #2

Post your reply

Help answer this question



Didn't find the answer to your Microsoft Access / VBA question?

You can also browse similar questions: Microsoft Access / VBA