Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 04-05-2022, 06:47 AM
grNadpa grNadpa is offline Word report from Excel table Windows 10 Word report from Excel table Office 2016
Advanced Beginner
 
Join Date: Mar 2022
Posts: 46
grNadpa is on a distinguished road
Default

I have only done one Word 2016 vba application. But mine appears to face similar challenges to yours. Since you have not enjoyed any other responses, let me share my thoughts.

Rather than mail merge, have you considered storing bookmarked documents in Word's "Building Blocks"?

My project involved three types of documents: A Partial waiver, a Final waiver and a Notary form. The partial waiver can run multiple pages. I generate a notary page after the last partial page. The one-page final waiver incorporates the notary page, so it doesn't need a separate page. And the notary page itself can be a standalone document.

I used bookmarks in the documents to mark for the variables and saved each document as a Building Block entry in Word's Quick Parts (Insert > Text > Quick Parts > Save Selection to Quick Parts Gallery ...).

Loading and populating the forms through Word VBA forms is not particularly intuitive. And I overstayed my welcome with my posts to the StackOverflow forum as I struggled with it.

But Building Blocks might be an alternative to consider.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filename options when saving in Word 2013 - using report number at top of a report ? swayzak Word 1 09-08-2017 08:54 AM
Switch slicer report connections between pivot table and table tyjulianchen Excel 0 02-28-2017 04:54 AM
Avaya split/skill report to Excel - Pivot Table BigErnKingpin Excel 0 02-13-2017 05:28 AM
Word report from Excel table How to extract data from Excel database to create word report for each patient (row) nightale Word 3 07-06-2014 04:17 PM
Word report from Excel table count word by word automatically with a report in a table febec88 Word VBA 3 05-14-2014 03:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:25 AM.


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