Hi Peter,
Each client has their own row which can have up to 12 payments (maybe more a
year down the line). There are no gaps between payments.
Example of payments is as follows:
Name Surname Pay1 Int1 Date1 Pay2 Int2 Date2 Pay3 Int3 Date3 Etc.
John Brown 100 10 9/8/8 200 20 15/9/8 100 10 7/10/8
Mark Black 500 50 15/9/8 300 30 20/12/8
Mary White 400 40 1/4/8 700 70 3/6/8 600 60 9/8/8
Etc..
"Peter Jamieson" wrote:
Can you be a bit more specific about how the data is set up in your Excel
table? Is each payment in a separate row in the table? Or can you have up to
12 payments in the same row? If you can have up to 12 payments in the same
row, can there be gaps, like this
p1 p2 p3 p4 p5 p6 p7 p8 p9 p10 p11 p12
10 12 8 5
or what?
I have a word template that I need to merge to from an Excel table. The
template can show 5 payments next to each other in columns.
Also for this: how does your output need to look if there are 5 payements? 6
payments? 12 payments?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Rayashe" wrote in message
...
Hi,
I am operating on Office 2007.
I have a word template that I need to merge to from an Excel table. The
template can show 5 payments next to each other in columns.
Problem is that some clients may have only had one payment and others can
have up to 12 payments.
What can I do so that if clients have had 5 payments or less, then it will
not print/email/merge to another 2 pages that will have no entries?
Thanks.