Mail merge inception
Hello,
I need to find a way to implemetn a mail merge into mail merge:
I issue up to 30 orders for exploitation of company cars a day and I want to automate the process.
The problem is, that the form I'm trying to achieve is the following.
"Order
for exploitation of vehicle, property of <<company>>, Technical ID <<Tech ID>>, <<model>>, <<type>>
The following employees:
1. <<Employee name 1>>, Car license number <<Car license number1>>, Address <<Address1>>, etc..
2. <<Employee name 2>>, Car license number <<Car license number2>>, Address <<Address1>>, etc..
...
n. <<Employee name n>>, Car license number <<Car license numbern>>, Address <<Addressn>>, etc..
should drive the vehicle with the care of the good husband,
etc. etc.
Declare that they are familiar with the consumption rates, as it follows:
-Main consumption rate <<main consumption rate>>
-Country consumption rate <<country consumtion rate>>
etc. etc."
I have both car attributes (m) and employee attributes (n), for each car I can have a different number of employees.
Can somebody help me find a way to create it as a mail merge form, and help me find a way to represent the initial excel data?
Thank you!
|