Jump to content
Welcome to the new FusionPro User Forum! ×

Merge Names with same address


Recommended Posts

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


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!

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...