Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-09-2012, 04:09 AM
jelarbey jelarbey is offline Create and populate multiple templates with merge tags Windows 7 32bit Create and populate multiple templates with merge tags Office 2012
Novice
Create and populate multiple templates with merge tags
 
Join Date: Oct 2012
Posts: 1
jelarbey is on a distinguished road
Default Create and populate multiple templates with merge tags


Hi

I have 8-9 Documents that I have to create for different cases. Each document remains largely the same with a few details changed each time. Is there a way of having an excel sheet with the changed data on and using it to populate a group of templates all at once.

i.e. I create an excel sheet with the unique data apply it to group of templates and word creates 9 unique documents.

Thanks, Jonathan
Reply With Quote
  #2  
Old 10-09-2012, 05:20 AM
macropod's Avatar
macropod macropod is offline Create and populate multiple templates with merge tags Windows 7 64bit Create and populate multiple templates with merge tags Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you configure the Excel workbook so that the data the Word document are to reference are always in the same location (eg by having a separate worksheet where the reference data appear), you can create links by copying the Excel cells, then pasting the content into Word using Paste Special with the 'paste link' option. Note that several paste formats are supported. Experiment to see which format(s) best suit your needs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
merge, template

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create charts and graphs as in templates. rohit007 PowerPoint 0 08-16-2012 12:18 AM
Managing multiple templates dtenter PowerPoint 0 05-22-2012 09:20 AM
Create and populate multiple templates with merge tags Templates, pictures, Mail Merge and Excel kckay Word VBA 1 05-17-2012 08:51 PM
Share VBA variable in multiple templates shameerau Word VBA 0 07-05-2010 08:37 PM
Create Multiple Tabs from Template TeePee Excel 0 04-30-2009 11:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft