loop to create multipage doc with single page tempate   

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

date: Fri, 2 Nov 2007 15:15:23 -0700   author:   nycdon

Re: loop to create multipage doc with single page tempate   

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"  wrote in message 
news:94A29E06-00D3-4DD6-9D8A-60A3B8AFC0E6@microsoft.com...
>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

date: Sun, 4 Nov 2007 09:24:43 +1000   author:   Doug Robbins - Word MVP

Re: loop to create multipage doc with single page tempate   

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" wrote:

> 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"  wrote in message 
> news:94A29E06-00D3-4DD6-9D8A-60A3B8AFC0E6@microsoft.com...
> >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 
> 
> 
>

date: Sun, 4 Nov 2007 08:53:00 -0800   author:   nycdon

Re: loop to create multipage doc with single page tempate   

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"  wrote in message 
news:2BF83ED7-C5EC-4FFA-A924-C6F34A075807@microsoft.com...
> 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" wrote:
>
>> 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"  wrote in message
>> news:94A29E06-00D3-4DD6-9D8A-60A3B8AFC0E6@microsoft.com...
>> >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
>>
>>
>>

date: Mon, 5 Nov 2007 05:21:49 +1000   author:   Doug Robbins - Word MVP