loop to create multipage doc with single page tempate

N

nycdon

I want to loop thru an Access recordset, and create multiple pages from same
1 page
Word template. I can create one page ok with, but I'[m not sure how to add
another page, (using same template), using next row from Access.
(the Access part I know, just not how to start another page, and loop back
to insert first bookmark).
Perhaps I should ask if this is most efficient way to do?

Thanks!
don
 
D

Doug Robbins - Word MVP

Have you considered using mail merge? Seems like you are re-inventing the
wheel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
N

nycdon

Thanks Doug - at runtime, can Mail Merge process be initiated/instantiated
from within an Access app? Or is manual from Word..

Doug Robbins - Word MVP said:
Have you considered using mail merge? Seems like you are re-inventing the
wheel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

nycdon said:
I want to loop thru an Access recordset, and create multiple pages from
same
1 page
Word template. I can create one page ok with, but I'[m not sure how to add
another page, (using same template), using next row from Access.
(the Access part I know, just not how to start another page, and loop back
to insert first bookmark).
Perhaps I should ask if this is most efficient way to do?

Thanks!
don
 
D

Doug Robbins - Word MVP

Yes, Mail Merge can be initiated from Access. You should find some things
of interest of fellow Access MVP, Albert Kallal's website at:

http://www.members.shaw.ca/AlbertKallal/wordmerge/index.html

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

nycdon said:
Thanks Doug - at runtime, can Mail Merge process be initiated/instantiated
from within an Access app? Or is manual from Word..

Doug Robbins - Word MVP said:
Have you considered using mail merge? Seems like you are re-inventing
the
wheel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

nycdon said:
I want to loop thru an Access recordset, and create multiple pages from
same
1 page
Word template. I can create one page ok with, but I'[m not sure how to
add
another page, (using same template), using next row from Access.
(the Access part I know, just not how to start another page, and loop
back
to insert first bookmark).
Perhaps I should ask if this is most efficient way to do?

Thanks!
don
 

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