Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BadBoy House
Starting Member
41 Posts |
 Posted - 2009-10-07 : 12:00:17
|
| Apologies if this is in the wrong section. We currently merge data into Microsoft Word from an Access database.Over the next few months we're going to be changing to an SQL version of the database. Obviously we still need to be able to merge client addresses and other information directly into standard letters (containing merge fields).Is there a way using Microsoft Word to connect to an SQL database and use it as the data source - the same as how we currently connect to our access database as the data source?Does anyone know the exact steps to merge data from an sql database into a Microsoft Word template and add data fields etc?thanks |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-15 : 08:08:33
|
| Yes, you can connect to SQL Server for mail merge. You'll need the OLEDB provider for SQL - it maybe installed with Office.Once you connect the steps to merge the data are the same as when using Access. |
 |
|
|
|
|
|
How do you merge from an SQL database into MS Word