An interesting attempt. Turning the tedious directory work in Excel & Word into Access GUI.
Cool trick: Round-up / Ceiling of a positive double:
In VB.NET, using the fact that int() = floor()
-Int(-a/b)
It would appear that some MS Word pages do not follow the same line number limit as the rest of the pages. There's a math (or here) to make it work:
Word uses points. 72 points = 1 inch. Single line spacing is 120% of font size. This may be kind of tricky (footer/header margins are not accounted for in the article, which I think they should). For some reason the margins left about 9.3" of writing space per page, taking away 1.6" which I have no clue how it came about. Or I may pursue a different approach programmatically.
There was a problem in my code:
I keep getting Run-time error '462':
The remote server machine does not exist or is unavailable. Debug targets
ObjWord.Selection .Paragraphs.TabStops
.Add Position:=InchesToPoints(1.5), Alignment:=wdAlignTabLeft
Solution: ObjWord.InchesToPoints(1.5)
So far so good, if the spacing calculation for getting every page to start with a new contact is still a problem, then perhaps it's better to program a page break into it.