fabio.dero79
New member
- Joined
- Mar 3, 2019
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office365
Hello,
I am trying to get a mail merge where I want separated email to be sent to a list of accounts.
I would like James Green to receive one email only stating:
21/11/2018 89
26/12/2018 34
And same for Thomas Reed and so on.
Then the perfect scenario would be to also have the subtotals, but this is not extremely important:
I have tried in many different ways to use the formula "nextif" but I still cannot work it out.
Do you have any suggestion/tutorial to share?
Many thanks,
Fabio
I am trying to get a mail merge where I want separated email to be sent to a list of accounts.
I would like James Green to receive one email only stating:
21/11/2018 89
26/12/2018 34
And same for Thomas Reed and so on.
Name | Date | Amount |
James Green | 21/11/2018 | 89 |
James Green | 26/12/2018 | 34 |
Thomas Reed | 14/12/2016 | 22 |
Thomas Reed | 27/05/2018 | 88 |
Then the perfect scenario would be to also have the subtotals, but this is not extremely important:
Name | Date | Amount |
James Green | 21/11/2018 | 89 |
James Green | 26/12/2018 | 34 |
James Green Total | 123 | |
Thomas Reed | 14/12/2016 | 22 |
Thomas Reed | 27/05/2018 | 88 |
Thomas Reed Total | 110 | |
Grand Total | 233 |
I have tried in many different ways to use the formula "nextif" but I still cannot work it out.
Do you have any suggestion/tutorial to share?
Many thanks,
Fabio