Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-13-2024, 06:55 PM
Guessed's Avatar
Guessed Guessed is offline Userforms to produce long Word document Windows 10 Userforms to produce long Word document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
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

There isn't one best solution, it really depends on several things.
1. How is the Excel data created/updated?
2. Is the data going in to Word tabular or individual fields?
3. Are data fields appearing in Word in multiple locations? (Same info in multiple places)
4. What value is added by doing data entry in Excel rather than starting in Word?
5. Are individual documents produced or are you outputting a series of documents at the same time?

Solution options involving initial data entry in Excel could be:
- Mail merge
- Export to custom XML file which then gets embedded in Word which contains mapped content controls
- Macro to populate fields/bookmarks or Content Controls

I note that you asked if you should put the info directly in to Word so you are already thinking about Q4 above. If Excel adds no value then perhaps a Word only solution would be simplest and easiest to implement. I would be most likely to recommend a Word only solution unless you are producing multiple concurrent docs
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Userforms to produce long Word document Incorrect page-numbering in a long Word document BillMcEnaney Word 16 04-19-2019 11:30 PM
Userforms to produce long Word document How to scroll through a long Word document on an iPad DavidR77 Word 5 03-31-2015 08:08 AM
Easiest Way to Produce a Report/List of Tagged Text from Multiple Word Files bxchk Word 5 04-29-2014 03:23 PM
Using Word 2007 to produce a mail merge byjemany Mail Merge 1 11-15-2013 11:25 PM
How much long auhtentic is a word document? plaszma Word 0 11-08-2009 09:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:06 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