U8. Software Integration for Teaching and Learning. Presented by: Law Hing Man (13 Dec 2001). 8.1 Overview of Software Integration. Applications developed by integrating various software commonly available.
Presented by: Law Hing Man
(13 Dec 2001)
8.3.1 Mail Merge
Word – Main document
The document that contains the contents that are the same for all merged documents.
Excel – Data source file
The spreadsheet that contains the contents that are different for all merged documents.
Use Word to create the following document.
Use Excel to create the following spreadsheet.
Step3.1: In Word, open the main document.
Step3.2: Choose Tools, Mail Merge.
Step3.5: Choose Get Data, Open Data Source
Step3.8: Fill in the fields with the help of <Insert Merge Field> button in the button bar.
Step4.1: Choose Tools, Mail Merge.
Step4.2: Choose Merge
Design a report card using mail merge. The data file is marks.xls. The first card should be like this:
Eg. Copy an Excel spreadsheet to a Word document without OLE.
Change / Not ?
CHAN TAI MAN
CHOI CHI MING
CHAN SIU MING
LEE TAI KEUNG
LAM TIN KWONG
CHEUNG LAI HEUNGExercise 2
Copy an Excel bar chart to a PowerPoint without OLE. The chart is based on the file marks.xls.
Set animation effects for the bars.
Eg. Copy an Excel spreadsheet to a Word document with OLE.
Change / Not ?
Repeat exercise 2 by with OLE.
Change the marks in spreadsheet and note if there are any changes in Powerpoint.
Eg. Invoke an Excel spreadsheet from a PowerPoint presentation.
*To edit a hyperlink, repeat the above steps.
*Use relative path as far as possible.
Setup two hyperlinks in PowerPoint. One links to the Word document main.doc and the other links to the Excel spreadsheet data.xls.