MS Word OLE Mail Merge and Office ApplicationsMS Word - OLE Mail Merge and Office Applications
OLE, Mail Merge, and Office Applications
OBJECT LINKING AND EMBEDDING
Choose Between Linking and Embedding Objects
Update, Edit, and Break Links
MAIL MERGES
Perform a Basic Mail Merge
Create a Smart Mail Merge With Sorting, Filtering, and if Fields
Insert Data Source Fields into a Merge Document
Edit a Data Source Document
Filter Using a Numerical Field
Restore a Mail Merge Document to a Normal Word Document
WORD AND EXCEL
Keep an Excel Chart Updated in a Word Document
Transfer Data from Word to Excel
WORD AND POWERPOINT
Create a Document from a Presentation
Create a Presentation from a Document
Put a Word Table on a PowerPoint Slide
WORD AND ACCESS
Convert a Word Table to an Access Database
Move Data from an Access Table to a Word Document
This tutorial starts by nailing the key object linking and embedding (OLE): how to choose between linking and embedding, and how to deal with broken links after one of your colleagues has made the wrong choice. The tutorial then shows you how to deal with the grievances typically aired about mail merging, from using filtering and fields to create a smarter mail merge to convincing Word that a document really isn't a merge document anymore.