By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Access query records to Word

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


P: n/a
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" <jo******@comcast.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
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 #2

This discussion thread is closed

Replies have been disabled for this discussion.