Hi--
I have multiple school groups for one school name/contact -- how do I get them to merge into one doc. for each contact? The wizard just picks up each row and it creates a new doc. for each line... so a contact with 15 schools gets 15 docs.... this is what my excel doc looks like.
<table border="0" cellpadding="0" cellspacing="0" width="641"><col style="width: 44pt;" width="59"> <col style="width: 104pt;" width="138"> <col style="width: 48pt;" width="64"> <col style="width: 125pt;" width="166"> <col style="width: 86pt;" width="114"> <col style="width: 75pt;" width="100"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; width: 44pt;" height="20" width="59">Contact</td> <td class="xl68" style="border-left: medium none; width: 104pt;" width="138"> _DIST_NAME</td> <td class="xl68" style="border-left: medium none; width: 48pt;" width="64">STATE_ID</td> <td class="xl68" style="border-left: medium none; width: 125pt;" width="166"> _NAME</td> <td class="xl69" style="border-left: medium none; width: 86pt;" width="114">WRKDAY_START</td> <td class="xl69" style="border-left: medium none; width: 75pt;" width="100">WRKDAY_END</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">Mary</td> <td class="xl70" style="width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-left: medium none; width: 125pt;" width="166">Mary Hogan </td> <td class="xl67" style="border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Bridport Central </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Shoreham Elementary </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Bingham Memorial </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Salisbury Community </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Ripton Elementary </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Weybridge Elementary </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Middlebury Union Middle </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">8:00 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Middlebury Union High </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">8:00 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> </tbody></table>Thank you!!
I have multiple school groups for one school name/contact -- how do I get them to merge into one doc. for each contact? The wizard just picks up each row and it creates a new doc. for each line... so a contact with 15 schools gets 15 docs.... this is what my excel doc looks like.
<table border="0" cellpadding="0" cellspacing="0" width="641"><col style="width: 44pt;" width="59"> <col style="width: 104pt;" width="138"> <col style="width: 48pt;" width="64"> <col style="width: 125pt;" width="166"> <col style="width: 86pt;" width="114"> <col style="width: 75pt;" width="100"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl68" style="height: 15pt; width: 44pt;" height="20" width="59">Contact</td> <td class="xl68" style="border-left: medium none; width: 104pt;" width="138"> _DIST_NAME</td> <td class="xl68" style="border-left: medium none; width: 48pt;" width="64">STATE_ID</td> <td class="xl68" style="border-left: medium none; width: 125pt;" width="166"> _NAME</td> <td class="xl69" style="border-left: medium none; width: 86pt;" width="114">WRKDAY_START</td> <td class="xl69" style="border-left: medium none; width: 75pt;" width="100">WRKDAY_END</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">Mary</td> <td class="xl70" style="width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-left: medium none; width: 125pt;" width="166">Mary Hogan </td> <td class="xl67" style="border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Bridport Central </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Shoreham Elementary </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Bingham Memorial </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Salisbury Community </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Ripton Elementary </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Weybridge Elementary </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">7:30 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Middlebury Union Middle </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">8:00 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt;" height="20">
</td> <td class="xl65" style="border-top: medium none; width: 104pt;" width="138"> Central S. U.</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 48pt;" width="64">VT</td> <td class="xl66" style="border-top: medium none; border-left: medium none; width: 125pt;" width="166">Middlebury Union High </td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 86pt;" align="right" width="114">8:00 AM</td> <td class="xl67" style="border-top: medium none; border-left: medium none; width: 75pt;" align="right" width="100">4:00 PM</td> </tr> </tbody></table>Thank you!!