VB.NET VS 2010 Word Mail Merge-How to insert text in footer

[pinokio]

Summary of my efforts.
VB.NET (VS 2010)
Word 2007
SQL 2008
1. I have 2 different letters(each n pages) to be merged with sql datasource and word template for the letter.
2. I want to tag each page of each letter with a code placed at the footer of each page of the letter that will determine destination folder of the letter.
3.The datasource has the code for each record.
4. I cycle through Activedocument of record.
5. I cycle through the footer for each section of Active document.
PROBLEM
Each letter is inserting one type of code on all pages accross type.
Example of ideal end result
Template - A
2 letters - each letter is 3 pages
letter 1 code = L_one_1 should be on all footers of letter 1
letter 2 code = L_two_2 should be on all footers of letter 2

Current end result
Both letters have code for letter 2

My question is - How to insert tags at the footer for each letter in the template.

This is very annoying. Any help will be appreciated since I have spent two days already.

[pinokio]

I just finished a lengthy debugging process and I figured out what I need. The question now is how do I get it.
Okay so my ActiveDocument actually contains both letters. I want a different footer for each letter within the ActiveDocument.
Thank you