Hi EE Experts,
We are moving from Office 2003 to Office 2010, so am testing mdbs under Access 2010.
The Mail Merge doc created from the mdb under Access 2010 is a little different than what Access 2003.
Will point them out in screen shots below.... is there anything I can modify in the Word doc (that I use as a template)
Will also paste the components of this project:
a) mdb - simplified by removing forms etc.... pls go to modules, and run: Test()
b) excel - test data
c) word - mail merge doc
d) a student doc for Thomas Jefferson created by Access 2003 mail merge under XP
When you run Test(), it will execute a mail merge doc containing 3 students, then it breaks up the big doc to 3 docs for each student.
This is the Mail Merge Access 2003 version.
a) Please see the red circle - Date is all 1 font: Times New Roman 12
b) Please see the blue square - Dates are aligned
This is the Mail Merge - Access 2010
a) Please see the red circle - it's Arial now, and different font size between Month and Year
b) Please see the green square - too much blank space, some blank space we want bec that's where letterhead goes
c) Please see the blue square - it's hard to see with my test, but the dates are not aligned, bec the next date continues on the next page so have to give you a screen shot for page 2
Showing the blue square of misalignment by taking a screen shot in Word itself (not print preview)
Your help is very much appreciated. Will paste the project components below....