Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2021, 02:38 PM
Guessed's Avatar
Guessed Guessed is offline Loading building blocks from SQL server when opening word from application Windows 10 Loading building blocks from SQL server when opening word from application Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't know if this forum has many .NET specialists, so pretty much all examples here are VBA which you would need to adapt to .NET. My last post above for example shows you how to insert a building block from the attached template in VBA.

I think perhaps you might be interested in mapped Content Controls which probably better aligns with getting field data from SQL and putting it into the right places in the Word document. Mapped CCs can be included in building blocks to allow you to customise document content at multiple levels.

A couple of threads worth exploring are:
https://www.msofficeforums.com/word/...challenge.html
https://www.msofficeforums.com/word/...-document.html

If you are using mapped CCs to your own embedded xml file, it is relatively simple to replace that xml file from sql database content.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
building blocks, macros, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to add building blocks in Word by VBA also in footer avogt Word VBA 3 04-26-2018 06:35 AM
VBA Word - Building Block (AutoText) - Array - Replace Text with Specific Building Blocks jc491 Word VBA 7 01-03-2016 10:34 PM
Building blocks show correctly in dropdown, but wrong building block populates in doc wordgirl123 Word 0 10-03-2013 08:30 AM
INSERT building blocks from Quickpart in word jasserin Word VBA 0 06-05-2013 12:55 PM
Word - Attach Building Blocks namedujour Word 0 04-04-2011 09:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 PM.


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