JugglerJAF
Active Member
- Joined
- Feb 17, 2002
- Messages
- 297
- Office Version
- 365
- Platform
- Windows
(Apologies of this needs to be in a Word forum, but it is 50% Excel related!)
I have some data that I use to create a mailmerge, and in its raw form, the data looks like this:
<tbody>
</tbody>
From this, I need a mailmerge to produce 3 letters (one each addressed to Alpha, Bravo, and Charlie) and each letter needs to show the support description and price for all available products, so the final output would be:
1 letter to Alpha, listing two levels of support (a1 and a2), and their associated prices (£11 and £12)
1 letter to Bravo, listing three levels of support (b1, b2, and b3), and their associated prices (£12, £22, and £24)
1 letter to Charlie, listing one level of support (c1), and its associated price (£33)
The current process for doing this requires the layout of the data file to be changed from the tabular "vertical" format above (6 rows, 3 columns) to a "horizontal" format (3 rows, six columns) as shown below.
<tbody>
</tbody>
Is there any way of doing the mailmerge with the data in the original layout so that I don't have to amend the layout every time?
I have some data that I use to create a mailmerge, and in its raw form, the data looks like this:
hardware | support | price |
Alpha | a1 | £11 |
Alpha | a2 | £12 |
Bravo | b1 | £22 |
Bravo | b2 | £24 |
Bravo | b3 | £26 |
Charlie | c1 | £33 |
<tbody>
</tbody>
From this, I need a mailmerge to produce 3 letters (one each addressed to Alpha, Bravo, and Charlie) and each letter needs to show the support description and price for all available products, so the final output would be:
1 letter to Alpha, listing two levels of support (a1 and a2), and their associated prices (£11 and £12)
1 letter to Bravo, listing three levels of support (b1, b2, and b3), and their associated prices (£12, £22, and £24)
1 letter to Charlie, listing one level of support (c1), and its associated price (£33)
The current process for doing this requires the layout of the data file to be changed from the tabular "vertical" format above (6 rows, 3 columns) to a "horizontal" format (3 rows, six columns) as shown below.
hardware | support_1 | price_1 | support_2 | price_2 | support_3 | price_3 |
Alpha | a1 | £11 | a2 | £12 | ||
Bravo | b1 | £22 | b2 | £24 | b3 | £26 |
Charlie | c1 | £33 |
<tbody>
</tbody>
Is there any way of doing the mailmerge with the data in the original layout so that I don't have to amend the layout every time?