Hi all,
I know how to use mail merge, if I were only to insert fields here and there in a text.
But what if I want a table of data in word?
For example, if I have the below data in Excel:
Cust Invoice Amount
A MC- 40401 18
A MC- 40394 30
A MC- 40393 12
B MC- 40393 24
B MC- 40392 15
B MC- 40396 19
B MC- 40395 27
B MC- 40399 15
C MC- 40400 25
C MC- 40400 21
C MC- 40399 19
D MC- 40391 14
D MC- 40401 27
D MC- 40396 23
I would like that in MS Word, if I scroll thru the field customer for customer A, the below will be in a table:
Invoice Amount
MC- 40401 18
MC- 40394 30
MC- 40393 12
And for B:
Invoice Amount
MC- 40393 24
MC- 40392 15
MC- 40396 19
MC- 40395 27
MC- 40399 15
and so forth.
Is this possible at all?
Thanks
I know how to use mail merge, if I were only to insert fields here and there in a text.
But what if I want a table of data in word?
For example, if I have the below data in Excel:
Cust Invoice Amount
A MC- 40401 18
A MC- 40394 30
A MC- 40393 12
B MC- 40393 24
B MC- 40392 15
B MC- 40396 19
B MC- 40395 27
B MC- 40399 15
C MC- 40400 25
C MC- 40400 21
C MC- 40399 19
D MC- 40391 14
D MC- 40401 27
D MC- 40396 23
I would like that in MS Word, if I scroll thru the field customer for customer A, the below will be in a table:
Invoice Amount
MC- 40401 18
MC- 40394 30
MC- 40393 12
And for B:
Invoice Amount
MC- 40393 24
MC- 40392 15
MC- 40396 19
MC- 40395 27
MC- 40399 15
and so forth.
Is this possible at all?
Thanks