advanced word training london - Word, populate data automatically

Resolved · Low Priority · Version Standard

Fri 13 Apr 2007, 14:06 Delegate Lorraine said...

Lorraine has attended:
No courses

Word, populate data automatically

Other than mailmerge is there a way that Word can automatically populate data in a document.

Mon 16 Apr 2007, 16:44 Trainer Tracy said...

RE: Word, populate data automatically

Hi Lorraine,

Thank you for the question.

From Word you can send data into a Powerpoint presentation, File>Send to>Microsoft Powerpoint.

There are ways you can import Word data in from other applications, (in excel you could use Insert> Object), however, if you are looking to create letters/labels etc mailmerge is the most straightforward! remember you can choose your data source in the wizard so you can import the database from Access etc

Hope that helps

Tracy

Fri 20 Apr 2007, 08:43 Delegate Lorraine said...

RE: Word, populate data automatically

I should have said that I do not wish to send the data anywhere else. I am trying to create a type of form where I can type in a persons name at the top of the page in the address area and then have that first name of full name populated further on in the document.

Fri 20 Apr 2007, 11:15 Trainer Tracy said...

RE: Word, populate data automatically

Hi Lorraine,

There are limitations as to what word can do, and my initial thoughts are that you would need the initial data, in terms of names and addresses held on a database, i.e. Access. This would need to be linked to the Word document. Secondly you would need coding to tell Word where it was taking the data from and which parts, i.e last name, first line of address from recieving the initial instructions i.e. first name. So whilst I believe it is possible it is not straightforward and there are no simple functions on word where you can create this type of functionality.

Tracy

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Word tip:

Using Styles to create a header or footer.

Write your main title for the following pages in your document, i.e. Chapter 1, and apply a style to this title (Heading1 perhaps). Open your header using View-Header and Footer. Next choose Insert-Field and select the field named Styleref. In the next column headed "Style Name" select the style name that you applied to your main title. (Heading1 perhaps). Then press "OK". Your Header will now read Chapter 1 and will do so until you type in your next title i.e.Chapter 2 and apply the same style again to that new title.

View all Word hints and tips