Hello, I am looking for a way to process a bunch of statements via mail merge into Word. I know the basic functions of mail merge, but in this instance I wish to have the multiple contributions listed for each contributor.
Any suggestions? See sheet below
So the merge would pull data for each contributor as below.
john smith
name, address, etc
2014 Summary
Date Org Amount
1-5-14 1 $100
4-1-14 2 600
4-5-14 3 200
Any suggestions? See sheet below
Excel 2012 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | name | org | date | amount | ||
2 | john smith | org 1 | 1/5/2014 | $100.00 | ||
3 | john smith | org 3 | 4/5/2014 | $200.00 | ||
4 | john smith | org 2 | 4/1/2014 | $600.00 | ||
5 | bill jones | org 2 | 1/5/2014 | $200.00 | ||
6 | bill jones | org 4 | 1/6/2014 | $300.00 | ||
7 | bill jones | org 3 | 9/5/2014 | $60.00 | ||
Sheet1 |
So the merge would pull data for each contributor as below.
john smith
name, address, etc
2014 Summary
Date Org Amount
1-5-14 1 $100
4-1-14 2 600
4-5-14 3 200