[Aljaha]

Hey everyone,

Is there any way to create a database of categorised sentences in Office, that I can use to populate a document?

E.g. if the document was a review for a car magazine: have a number of prewritten sentences or phrases under various categories like 'loud engine' or 'good value' and put all these categories into a choose-able list. Then when I select the various categories, it populates a template document with the right content.

Is there a way of doing this in Office, or would I have to go elsewhere, and if elsewhere then where!

I have tried dropdown boxes on Word as well as Macros that work fine, just not as well as it could be.

Maybe I've bitten off more than I can chew. Thanks for any help you could give me!

[Advertisements]

In Word there are a couple of ways:

 

• Insert with AutoCorrect: Select a block of text that you want to populate. In the ribbon click File -> Options. In the Word Options dialog click Proofing and then Auto Correct Options. In Replace, enter a phrase to type that will auto populate the selected text. Best to start your phrase with a special character to prevent inserting it accidentally.
• Insert with Quick Parts: Select the text you want to populate. In the ribbon choose the Insert tab. Next click Quick Parts and choose Save Selection to Quick Part Gallery. To auto-populate click Quick Parts and click an entry from the gallery. You can also right click Quick Parts choose Add to Quick Access Toolbar. You'll find it just above the ribbon at the top of the window.

There are also a couple apps that can do similar functions.

• Phrase Express (free)
• Active Words (paid)

[admin]

In Word there are a couple of ways:

 

• Insert with AutoCorrect: Select a block of text that you want to populate. In the ribbon click File -> Options. In the Word Options dialog click Proofing and then Auto Correct Options. In Replace, enter a phrase to type that will auto populate the selected text. Best to start your phrase with a special character to prevent inserting it accidentally.
• Insert with Quick Parts: Select the text you want to populate. In the ribbon choose the Insert tab. Next click Quick Parts and choose Save Selection to Quick Part Gallery. To auto-populate click Quick Parts and click an entry from the gallery. You can also right click Quick Parts choose Add to Quick Access Toolbar. You'll find it just above the ribbon at the top of the window.

There are also a couple apps that can do similar functions.

• Phrase Express (free)
• Active Words (paid)