E
Eternally Lost
I am using Excel for my company's contract database. The entries are then
displayed and printed in Word on our contract template using the Mail Merge
function. In the past I have had to wait while Word updates itself when I
make a new entry in Excel. This would not be a problem except our database is
fairly large and the entry that Word stops on after the update is completely
random.
A few weeks ago I experienced a run-time error (one of many). After
restarting Word I noticed it no longer executed a full scan of the database
for each new database entry. It simply displayed the new entry. This was
quite a wonderful (and unprecedented) side-effect of the error. Unfortunately
a few days ago I experienced another run-time error and upon restarting Word
it went back to executing full scans for each new database entry.
My question is: Is there a setting in Word which will prevent it from
running a complete database scan at each new database entry? Barring that, is
there a way to force Word to end up on the new entry after the scan rather
than a random point in the database?
Thank you for your help.
Michelle
displayed and printed in Word on our contract template using the Mail Merge
function. In the past I have had to wait while Word updates itself when I
make a new entry in Excel. This would not be a problem except our database is
fairly large and the entry that Word stops on after the update is completely
random.
A few weeks ago I experienced a run-time error (one of many). After
restarting Word I noticed it no longer executed a full scan of the database
for each new database entry. It simply displayed the new entry. This was
quite a wonderful (and unprecedented) side-effect of the error. Unfortunately
a few days ago I experienced another run-time error and upon restarting Word
it went back to executing full scans for each new database entry.
My question is: Is there a setting in Word which will prevent it from
running a complete database scan at each new database entry? Barring that, is
there a way to force Word to end up on the new entry after the scan rather
than a random point in the database?
Thank you for your help.
Michelle