cheesiepoof05
Board Regular
- Joined
- Dec 30, 2010
- Messages
- 82
Hello all,
I am working on creating a mail merge document process from Excel to Word that splits based off of a 1 indicator in a certain column. Certain fields need listed all under the same document but change in length for row count. I thought it might be easier to create a short sample of what I'm doing. So the example below would create three different documents. With each one listing the class at the top and then a list of Animals and Colors below it. I appreciate your help. I'm trying to avoid any 3rd party addins if at all possible, but wasn't sure if Excel/Word had this ability inherently. Thanks!
<tbody>
</tbody>
Mail Merge Sample (please note while the list part doesn't appear to be in a grid, I will need it to be.)
For the animal class of «CLASS»
<tbody>
</tbody>
Mail Merge Sample for first document
For the animal class of MAMMALS
<tbody>
</tbody>
I am working on creating a mail merge document process from Excel to Word that splits based off of a 1 indicator in a certain column. Certain fields need listed all under the same document but change in length for row count. I thought it might be easier to create a short sample of what I'm doing. So the example below would create three different documents. With each one listing the class at the top and then a list of Animals and Colors below it. I appreciate your help. I'm trying to avoid any 3rd party addins if at all possible, but wasn't sure if Excel/Word had this ability inherently. Thanks!
<tbody> </tbody> |
<tbody>
</tbody>
Mail Merge Sample (please note while the list part doesn't appear to be in a grid, I will need it to be.)
For the animal class of «CLASS»
«ANIMAL» | «Color» |
<tbody>
</tbody>
Mail Merge Sample for first document
For the animal class of MAMMALS
DOG | Brown |
MOOSE | Brown |
MOOSE | Gray |
RABBIT | White |
ZEBRA | Striped |
<tbody>
</tbody>
Last edited: