DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Print Production & Automation

Reply
 
Thread Tools Display Modes
Old 09-20-2016, 05:03 AM   #1
kclson
Member
 
Join Date: Sep 2016
Posts: 2
Default MS Word Mail Merged documents

Is it possible to produce a variable data, mail merged MS Word document that will sort the merging to match a BULK mail USPS bar coded sorting order to match separately sorted addressed envelopes to a MS Word mail merged document? Assuming that additional software is required for the MS Mail merged document. We use Smart Addressing software for the BULK mail USPS bar coded BULK mail sorting.
kclson is offline   Reply With Quote
Old 09-20-2016, 07:31 AM   #2
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,709
Default

Quite a few programs will export data to Excel or CSV (comma separated value) format which can be imported into Excel. Once there, sorting the data on any of the fields is simple and once sorted, the sort order should be preserved when merging from Excel data to Word.

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Old 09-20-2016, 08:21 AM   #3
kclson
Member
 
Join Date: Sep 2016
Posts: 2
Default Re: Sorting

Thanks for your reply Steve. The issue of sorting the Excel file is not a simple matter of sorting the file by fields, but by USPS BULK mail regulations according to destination as per their pre-sort regulations which are not specifically simply city, state or zip code oriented. We use a proprietary software solution (Smart Addresser ) for this that sorts labeling newsletters or addressing envelopes that pre-sorts them into trays for BULK mail presorted postal delivery. However if a customer provides a mail merged multipage document to us (ie; each page is a personal variable data letter with address and personalized specifically to them) and the customer wants envelopes labeled from the same mailing list for BULK mailing, the sorting of the letters to put in the labeled envelopes becomes difficult due to the fact that no sorting available for MS Word documents matches up with USPS Bulk mail sorting.
kclson is offline   Reply With Quote
Old 09-20-2016, 01:44 PM   #4
terrie
Staff
 
Join Date: Oct 2004
Posts: 8,916
Default

I have no experience with this but let that not stop me...'-}}

I'm suprised that there isn't some 3rd party software that would do this because my guess is that this is not a rare need--basically some way to link the specific letter to the correct (addressed) envelope. It seems to me that each letter would need some sort of identifying code (essentially internal and not necessarily printed) which would function as the sort key allowing you to sort the data (the letters prior to printing) so that the letters would print in sort order "matching" the appropriate envelope?


Terrie

PS: Welcome to the forum...'-}}
terrie is offline   Reply With Quote
Old 09-21-2016, 05:59 AM   #5
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,709
Default

If the specialized software can export to CSV/XLS/etc (ie, any format that Word can merge from), could you then let IT do the sorting and export the sorted results for merge with the Word docs?

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Protecting Word documents Robin Springall Print Design 30 12-08-2010 06:06 AM
Melding two ID documents motoeric Print Design 1 02-02-2010 05:51 AM
Interactive: Word 2003 to Word 2007 command reference guide Michael Rowley Software 2 06-22-2007 10:36 AM
InDesign problem with merged cells in tables iskreto Print Design 7 12-06-2006 08:53 AM
Acrobat 7 and Word documents Michael Rowley Print Production & Automation 0 06-19-2005 12:43 PM


All times are GMT -8. The time now is 04:12 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.