Hi,

I was wondering if there was a way to share information between several Office applications. For instance, have a certain passage of text in a Word that I can use in another application. Any changes made to the text is updated in all locations.

It is obvious I would need some sort of central location for storing the information. Does anyone have any ideas?

Many thanks.

Yes, Office has extensive data sharing capabilities. Data can be shared amongst Access, Word, Excel, PowerPoint, Outlook, etc. and Office really doesn't care which data are stored where. Defining the data relationships and how/when they are to be shared is the real challenge. You probably don't want to share most of the data amongst applications, or even between files within a given application.

Access is a specialised data storage application (a database), though for many people, Excel (with its table structure) serves perfectly well.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]