Chief_Fred
New Member
- Joined
- Apr 20, 2012
- Messages
- 22
I have a table of policy holders that has data I need to get into a word document which would be simple enough except that the individual may appear more than once and the data must end up in a Word table with a completely different layout. This is a standard form letter I get from corporate for some accounts but which I must created from data in others. I can't change the layout of the letter. I was going to attach the excel and word documents you'd need to work on this but I find I can't post attachments and without those it's hard to visualize. I have inserted the data from Excel and the letter which is a table as well.
I have no idea where to begin.
Fred
<colgroup><col><col span="4"><col><col span="9"></colgroup><tbody>
</tbody>
<tbody>
</tbody>
I have no idea where to begin.
Fred
Last Name | First | MI | Policy # | Emp Total Policies | Line Of Business | Face Amount | Deduction Amount | Dept # | Pre-tax Status | Post-tax Status | CoverageType | Emp Sub tot Amt | URM | DDC |
JONES | SUZANNE | H | PXX86899 | CANCER | $41.99 | 41.99 | 0 | IND | 250 | |||||
JONES | SUZANNE | H | PG42158 | LIFE | $30.75 | 0 | 30.75 | IND | 125 | |||||
JONES | SUZANNE | H | PS456789 | 3 | ACC | $21.58 | 00TX | 21.58 | 0 | IND | $94.32 | |||
SMITH | KALLIE | E | Z0199999 | 1 | LIFE | $10,000 | $4.08 | 0 | 4.08 | T-25 | $4.08 | |||
SMITH | KIRBY | R | Z0888888 | 1 | LIFE | $10,000 | $4.08 | 0 | 4.08 | T-26 | $4.08 | |||
SMITH | SHARLA | J | P5XX3280 | ACC | $45.50 | 00TX | 45.5 | 0 | FAM | |||||
SMITH | SHARLA | J | P40162YY | CANCER | $99.97 | 99.97 | 0 | FAM | ||||||
SMITH | SHARLA | J | P4QQQ38 | ICARE | $17.54 | 17.54 | 0 | FAM | ||||||
SMITH | SHARLA | J | P4010000 | 4 | CRITICAL ILLNESS | $28.40 | 28.4 | 0 | FAM | $191.41 | 250 | |||
WILSON | LORI | PM811111 | 1 | CANCER | $61.75 | 0 | 61.75 | FAM | $61.75 | 125 | ||||
HYATT | LARRY | R | PM726666 | CRITICAL ILLNESS | $71.24 | 71.24 | 0 | HSF | ||||||
HYATT | LARRY | R | P377777 | ICARE | $34.06 | 34.06 | 0 | FAM | ||||||
HYATT | LARRY | R | ZZQ66886 | LTC | $60.00 | 0 | 60 | IND | ||||||
HYATT | LARRY | R | PVVV6373 | DENTAL | $72.90 | 00TX | 72.9 | 0 | HSF | |||||
HYATT | LARRY | R | P3787777 | ACC | $45.50 | 00TX | 45.5 | 0 | FAM | |||||
HYATT | LARRY | R | P3733338 | 6 | CANCER | $117.13 | 117.13 | 0 | FAM | $400.83 | ||||
PRINCE | SHARON | L | P7249555 | ICARE | $8.70 | 8.7 | 0 | IND | ||||||
PRINCE | SHARON | L | LLC53724 | LTC | $53.00 | 0 | 53 | IND | ||||||
PRINCE | SHARON | L | P7249924 | 3 | CANCER | $50.44 | 0 | 50.44 | SPF | $112.14 | ||||
RALPH | JUSTIN | L | PX653888 | 1 | LIFE | $4.05 | 00TX | 0 | 4.05 | IND | $4.05 | |||
RALPH | JUSTIN | L | PUGG9845 | 1 | ACC | $50.31 | 50.31 | 0 | FAM | $50.31 | ||||
RALPH | GARY | L | PX799999 | CRITICAL ILLNESS | $73.45 | TX | 73.45 | 0 | HSF |
<colgroup><col><col span="4"><col><col span="9"></colgroup><tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>