dalea
06-19-2009, 01:31 PM
Love Excel Hate Word
I have a spreadsheet with approximately 15,000 delinquent tax accounts. Many taxpayers have more than one account. On the spreadsheet the column labeled "StmtID" holds a code signifying that the accounts with that code are the same taxpayer. In the "master" "doc" I've inserted the fields where the belong. The information at the top of the form letter ("tax statement") should not change until the "StmtID" changes. The fields that show in the table part of the form should be on separate lines for each of the vehicles. I don't know if this will take VBA code or if it can be accomplished without. Basically, I want to generate one bill per taxpayer with a separate line for each car that they owe taxes on.
Both the master "doc" and the data workbook are included in the "Merge.zip" file attached. I'm on Excel and Word 200 XP operating system-Novell network. Any help greatly appreciated to at least give me the skeleton of a solution. By the way, the attached workbook only has about 50 accouns which should be enough for demonstration purposes.
Dalea:help
I have a spreadsheet with approximately 15,000 delinquent tax accounts. Many taxpayers have more than one account. On the spreadsheet the column labeled "StmtID" holds a code signifying that the accounts with that code are the same taxpayer. In the "master" "doc" I've inserted the fields where the belong. The information at the top of the form letter ("tax statement") should not change until the "StmtID" changes. The fields that show in the table part of the form should be on separate lines for each of the vehicles. I don't know if this will take VBA code or if it can be accomplished without. Basically, I want to generate one bill per taxpayer with a separate line for each car that they owe taxes on.
Both the master "doc" and the data workbook are included in the "Merge.zip" file attached. I'm on Excel and Word 200 XP operating system-Novell network. Any help greatly appreciated to at least give me the skeleton of a solution. By the way, the attached workbook only has about 50 accouns which should be enough for demonstration purposes.
Dalea:help