OK. I know I am being a little incessant with my posting here...but I had a bit of a break through with understanding how the last person got this to work.
I'm not sure if I can explain this properly....
It looks like "something" is organizing the rows into groups, and then adding the data from the columns that aren't #1 into that column somehow.
Does that make sense?
Somehow, the fields that are number 1,2,3,4,5,6,7,8,9,10 are being created and populated with the data.
So....just to try and clarify one more time.
In excel their is a list
1
2
1
2
3
1
2
1
2
3
4
like that. Every row has a name, address...etc
Now, when I go to Word and open the "Edit Recipients" tool their are all these extra fields that don't exist in the excel document, and all of the number 1's now have data from 2,3, and 4 attached to them as "Last Name 2", "Last Name 3"...etc. Now, all of the rows from the excel sheet are listed, but only the ones that are labelled Number 1 have data in 2,3, and 4 sections, so I can simply include only the rows that have any data in "Last Name 2" and boom...all my documents are populated correctly.
Does this make any sense, how is this being accomplished? It seems the only thing that broke somehow is that the data is no longer being grouped and then added to 'Number 1'.
I feel like I'm taking crazy pills here...lol.
|