HPIvt Posted October 20, 2011 Share Posted October 20, 2011 Hello, I have a simple postcard mailing job that I'm working on, This is being sent out from a college to parents and students. We have a nice clean csv file with just standard columns Name Address 1 Address 2 City, State ZIP The problem is that they would like only one postcard to go to each household. I have many instances of parents and students that share the same address on separate lines such as... Student 50 Anywhere Street City, State ZIP Parent 50 Anywhere Street City, State ZIP How can I compose my document so that the postcard address with merge both the parent and student name with the shared address? Any help would be greatly appreciated! Quote Link to comment Share on other sites More sharing options...
rpaterick Posted October 20, 2011 Share Posted October 20, 2011 I would believe you could easily do this in your postal software. Merge DUPLICATE addresses together by their FULL NAME. What postal software are you using? Quote Link to comment Share on other sites More sharing options...
HPIvt Posted October 20, 2011 Author Share Posted October 20, 2011 I'm not using any postal software, we are a commercial printer, just getting into using Fusion Pro. The list we get comes from the client. This time around they are asking if it's possible to just send one per household, where previously a card was generated for all names on the list. I would think there is or is a way to make a rule for this? Quote Link to comment Share on other sites More sharing options...
rpaterick Posted October 20, 2011 Share Posted October 20, 2011 I would think there is or is a way to make a rule for this? I would believe there is a rule to do this but I'm not sure. You could also open the file up in Excel, select the DATA TAB in Excel, high-light the COLUMN you want to just have one address per household(ADDRESS LINE 1), Next to FILTER there is an ADVANCED selection to choose, just check UNIQUE RECORDS ONLY, and click OK. This will only select the first address is the list, so it could leave out either the parent or student through out the list. Probably would vary. To see if it's working properly, you could sort the list by ADDRESS LINE 1 and look for duplicate addresses. Once you have found a set, try out the suggestion I had to see if it will get you by? Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted October 21, 2011 Share Posted October 21, 2011 You could load up all the records with ExternalDataFileEx and merge them in JavaScript, like in this very similar example: http://forums.pti.com/search.php?searchid=340748 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.