Using VBA to create an autotext function for Word(95) normal.dot
Posted on 2002-05-01
Just to set the scene.
We have a moderate size organisation (30+ people).
Naturally alot of people in the organisation are typing alot of the same stuff in there letters.
I have toyed with using the built in autotext function that comes with word. I want to use it so I don't have to retype names of employees all the time. Autotext is excellent in this regard.
The problems I have with it is trying to maintain a list of autotext entries.
With an organisation of this size it is only after hours that I can access the normal.dot to make changes.
I tried creating a global template that soley contained the autotext entries (and to further be used to contain any other functions that I might write). I could not get this to work.
I think if it were possible this would be the ideal, to have a global template that I could change at any time, that was accesible by everyone using Word.
By other thought was to write a VBA macro in the normal.dot, have this link to a database, or spreadsheet that could be updated.
Again there is an issue with the database idea as we have no use for ms-access in our office and as such only have a few copies.
Have I made my needs clear enough?
Is it possible?
Can anyone may any suggestions/solutions?