frogster90
New member
- Joined
- Sep 26, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I'm trying to do an Excel to Word Mail Merge for Mailing Labels. However, I want it to skip over identical entries: ie. entries that have the same name. What's the best way to accomplish this?
For example if the names in the excel doc were:
I'd want it to Print labels as follows:
I tried to create a new column in Excel that was identical to the names column but just one row lower. Using this I could compare the two cells.
{ SKIPIF {MERGEFIELD "Name" } = { MERGEFIELD "Pre Name" }{MERGEFIELD "Name" }
{ MERGEFIELD "Address" }
etc...
{ NEXT }
However, this didn't work.
I'm trying to find a way of accomplishing this that does not require an additional step of filtering the data each time I do a mail merge, because it's something I'm doing repeatedly. I know there are SKIPIF and NEXTIF functions in Mail Merge but they don't seem to do what I'd hoped they would.
All advice appreciated.
For example if the names in the excel doc were:
Laureen Leverich |
Shaun Camillo |
Shaun Camillo |
Shaun Camillo |
Shaun Camillo |
Duncan Vantrease |
Duncan Vantrease |
Yi Pierri |
Sergio Danzy |
Haley Kalis |
Haley Kalis |
Haley Kalis |
Tawanda Hackley |
Xavier Hindle |
I'd want it to Print labels as follows:
Laureen Leverich |
Shaun Camillo |
Duncan Vantrease |
Yi Pierri |
Sergio Danzy |
Haley Kalis |
Tawanda Hackley |
Xavier Hindle |
I tried to create a new column in Excel that was identical to the names column but just one row lower. Using this I could compare the two cells.
{ SKIPIF {MERGEFIELD "Name" } = { MERGEFIELD "Pre Name" }{MERGEFIELD "Name" }
{ MERGEFIELD "Address" }
etc...
{ NEXT }
However, this didn't work.
I'm trying to find a way of accomplishing this that does not require an additional step of filtering the data each time I do a mail merge, because it's something I'm doing repeatedly. I know there are SKIPIF and NEXTIF functions in Mail Merge but they don't seem to do what I'd hoped they would.
All advice appreciated.