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 / January 2004

Tip: Looking for answers? Try searching our database.

control record sequence in 2 up postcard

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark Stewart - 07 Jan 2004 02:56 GMT
Sorry the subject line wasn't more descriptive.

I've got a two up postcard where the records have to stay
in a very specific order. The records are in a txt file
and are sorted correctly, but I would like to make a neat
improvement. Now, the specifics....

There are about a 1000 records, the actual number changes
slightly per merge. They print 1,2,3,4,5,6... (again 2
up). Is there a way to print in this order: 1, 501, 2,
502, 3, 503... Hopefully, the 501 (and up) would be a
variable automatically calculated to equal 1/2 of the
number of records.

As it currently prints out, we have to take the job to
Kinko's to get them cut, then manually collate the job.
Seems like a computer ought to be able to do that part.

Any ideas?

Thanks,
Mark

BTW, using Office 2000.
Graham Mayor - 07 Jan 2004 07:22 GMT
Word's merge will not handle this as it stands. I would suggest opening the
data file in Excel.
Add a column to the left of the data, then using Excel's smart fill, number
the first 500 records 1,3,5,7,9 etc
Number the remaining records from 501 - 2,4,6,8,10 etc.
Sort the file on the new numbered column, which will put the records in the
required merge order and merge using the Excel file as a data source.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP
      E-mail gmayor@mvps.org
     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Sorry the subject line wasn't more descriptive.
>
[quoted text clipped - 20 lines]
>
> BTW, using Office 2000.
 
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.