Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2011, 07:27 AM
RSchmidt RSchmidt is offline How do I dynamically update data in a Word Document from a database table Windows XP How do I dynamically update data in a Word Document from a database table Office 2007
Novice
How do I dynamically update data in a Word Document from a database table
 
Join Date: Jul 2011
Posts: 1
RSchmidt is on a distinguished road
Red face How do I dynamically update data in a Word Document from a database table

How do I dynamically update data in a Word Document from a SQL database table when the Word document opens?



I am working with a Disaster Recovery Plan that is 25 pages long. The company has 5 sites and each department at each site has a copy of the DRP, but with their department personnel in the plan. Page 3 has a list of the Recovery Team (unique to each department at each site), page 8 has a Call List (again unique to each department at each site), and page 4 thru 7 describes the responsibilities of each Recovery Team member, with the assigned persons name in the section title, for example:

Recovery Team Leader - Bob Smith

The company has a employee table in a SQL Server 2008 database.

What they want is to put all of these documents in a SharePoint 2007 document library and have them dynamically update with the latest personnel data from that Employee table when a DRP document is opened. That way as staff change positions, staff join or leave the company, or as a DRP team in a specific department at a site shrinks or grows, the Word document will automatically pull the correct data from the database. Thus saving them from retyping these documents constantly.

My questions are:

1. Is this even possible?
2. If 'Yes', how do you do it?

I've tried mail merge and linking to an Excel spreadsheet and nothing has worked properly. Any advice would be deeply appreciated.

R. Schmidt
.Net/SharePoint Developer
Tulsa, Ok
Reply With Quote
  #2  
Old 07-14-2011, 04:27 PM
macropod's Avatar
macropod macropod is offline How do I dynamically update data in a Word Document from a database table Windows 7 64bit How do I dynamically update data in a Word Document from a database table 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

Hi R Schmidt,

You could configure the document as a mailmerge main document, then use mailmerge to produce documents personalised for each site.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I dynamically update data in a Word Document from a database table Have Powerpoint dynamically update from an excel or other file? oshkosh PowerPoint 3 04-05-2016 06:10 AM
Using data entered in prompt to search database table BluRay Word 1 03-25-2011 01:47 AM
How do I dynamically update data in a Word Document from a database table Excel data to Word table Jaymond Flurrie Word VBA 2 02-27-2011 07:42 PM
Table of Contents does not update, when document is opened on other computer jaybo Word 1 01-25-2011 04:56 PM
Easy Update "Table of Contents" feature in Microsoft Word 2007 VS. Word 2010 Xarzu Word 0 09-22-2010 06:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 PM.


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