I Have a table of data as follows:
Item Code Desc Amount
S-GPS GPS Device 100 $
S-CBL GPS Cable 20 $
S-ACS GPS Accessories 20 $
S-CHR Fixing Charge 50 $
S-DISC Discount -10 $
TOTAL 180 $
and I want to print this Invoice using MS Winword mail merge
the point is my invoice printout page is pre-printed forms which has preprinted fields descriptions
From the above list two main notes the order of the pre-printed form of items is not the same as the order of the records (which mainly comes from set of records)
also there are certain items in the pre-printed form might not applicable for this record printout.
how I can design my mail merge form so I can print specific price of a specific item code next to its location in the pre-printed form.
I appreciate if some one can help me ASAP