Mail Merge?

[akeys5862]

---

I'm trying to figure out the best course of action to complete this template for all of our employees. If I have all of the raw data, how can I get it to spit out an individualized version of this template for each line? I will also have each employees name and a graph as well. I'd love everyone's advice!


[TABLE="width: 367"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Total Compensation [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD]Estimated Cash Compensation[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD] Base Pay[/TD]
[TD="align: right"]$1.00[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] Bonus Potential[/TD]
[TD="align: right"]$0.00[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SubTotal[/TD]
[TD="align: right"]$1.00[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Time Off Benefits[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD] PTO[/TD]
[TD="align: right"]$0.00[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] Sick[/TD]
[TD="align: right"]$0.00[/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]SubTotal[/TD]
[TD="align: right"]$0.00[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Benefit Compensation[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$2.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 2"]Zeal's Cost[/TD]
[TD]Your Cost[/TD]
[/TR]
[TR]
[TD]Medical[/TD]
[TD] [/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD]Dental[/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]Vision[/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]Life/AD&D[/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]LTD[/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]401(k)[/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]EAP[/TD]
[TD] [/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]$0.00[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD] [/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$1.00[/TD]
[/TR]
[TR]
[TD]Total Compensation[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]$3.00[/TD]
[/TR]
</tbody>[/TABLE]