Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2006

Tip: Looking for answers? Try searching our database.

How do I go back to merge first record?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Skyeblue - 05 Sep 2006 20:08 GMT
Hi
Is there anyway I could merge my records on the first page and again merge
the SAME records on the 2nd and 3rd pages - the 3 pages have different
subject headings.
Thank you
Peter Jamieson - 05 Sep 2006 22:22 GMT
There's no field code that can take you back.

You can either try to manipulate your data source so that it duplicates the
records you need in the sequence you need (not particularly easy in the
general case) or you can try to store the values in each record using SET
fields

e.g.

{ SET myrec1field1 { MERGEFIELD myfield1 } }
{ SET myrec1field2 { MERGEFIELD myfield2 } }

then use them when they are needed:

{ REF myrec1field1 }

etc. (all the {} need to be the special field braces you can insert using
ctrl-F9)

Whether that is workable deends on what you have to do. If you have an
arbitrary number of records that you need to repeat, it won't work. If you
always know you need to store the values from x records (say 3 records) you
may be able to get away with it.

Peter Jamieson

> Hi
> Is there anyway I could merge my records on the first page and again merge
> the SAME records on the 2nd and 3rd pages - the 3 pages have different
> subject headings.
> Thank you
fscodave - 06 Sep 2006 15:52 GMT
So there's no command like CHAINDATA(filename) in WP? That simply
reloads a data file, "chaining" it, either the original one or any one
you name, at the end of the merge. (WP also has nestdata and nestform
commands, to go to and back from data or form files.)

Honest, I'm not trying to be grumpy or snide, but several of the merges
I set up either use the chaindata command or recursively call the same
form with the CHAINFORM command. These commands were absolutely
fundamental to how several of the merges worked. I need to report this
back to IT.

David

> There's no field code that can take you back.
>
[quoted text clipped - 27 lines]
> > subject headings.
> > Thank you
Peter Jamieson - 06 Sep 2006 16:34 GMT
> So there's no command like CHAINDATA(filename) in WP? That simply
> reloads a data file, "chaining" it, either the original one or any one
> you name, at the end of the merge. (WP also has nestdata and nestform
> commands, to go to and back from data or form files.)

No, Word does not have any of that stuff.

> Honest, I'm not trying to be grumpy or snide, but several of the merges

Don't worry, I would much rather have a better Word, and I'm sure it's both
frustrating coming from a more flexible and powerful product and also
difficult to see what is feasible, what is easy, etc.

Peter Jamieson

> So there's no command like CHAINDATA(filename) in WP? That simply
> reloads a data file, "chaining" it, either the original one or any one
[quoted text clipped - 44 lines]
>> > subject headings.
>> > Thank you
fscodave - 06 Sep 2006 16:44 GMT
OK, thanks. I'll pass that on to IT. They'll have to change the dbf
output and rethink how those merges can work. Maybe some of the other
recommendations about changing the data files could be adapted to what
they do. (The database is currently FoxPro, but the plan is to switch
to Access.)

> > So there's no command like CHAINDATA(filename) in WP? That simply
> > reloads a data file, "chaining" it, either the original one or any one
> > you name, at the end of the merge. (WP also has nestdata and nestform
> > commands, to go to and back from data or form files.)
>
> No, Word does not have any of that stuff.
Cindy M. - 06 Sep 2006 17:03 GMT
Hi Fscodave,

> So there's no command like CHAINDATA(filename) in WP? That simply
> reloads a data file, "chaining" it, either the original one or any one
[quoted text clipped - 6 lines]
> fundamental to how several of the merges worked. I need to report this
> back to IT.

Nope, nothing like...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.