Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2023, 12:49 PM
tnt56 tnt56 is offline Auto Merge text from multiple sources Windows 10 Auto Merge text from multiple sources Office 2021
Novice
Auto Merge text from multiple sources
 
Join Date: Jun 2023
Posts: 1
tnt56 is on a distinguished road
Default Auto Merge text from multiple sources

Hello to everyone.
I have a problem and would like to know whether there is a realistic and sensible solution available through word functionality that will help me to save time.

Every month, I have to construct a single word document with the same structure (in terms of pages, paragraphs, graphics, etc.) but the information for writing its constituent paragraphs comes from various other word files that I receive by e-mail each month.

Now, since I have to merge and modify information from 50 different files every month, and I'd like to avoid opening each one and copying and pasting their components, is there a way for me to automatically build this general word file?

To better explain the concept, let's make an example.
Assume I have to construct this final word document with the following structure:

- paragraph 1: The king of the Nord
xxxxxxxxxx
xxxxxxx
xxxxx
(picture)

- paragraph 2: The king of the south
xxxxxxxxxx
xxxxxxx
xxxxx
(picture)

- paragraph X: ....


Every paragraph is pulled from other word documents that I receive via e-mail each month, and I'd like to avoid having to copy-paste them all to create the final word document.





Is there something that will automatically allow me to complete this task and save huge amount of time?


Thank you in advance to anyone who will be able to answer my request.

PS: I'm working with the 365-word version.
Reply With Quote
  #2  
Old 06-01-2023, 02:07 PM
Charles Kenyon Charles Kenyon is offline Auto Merge text from multiple sources Windows 11 Auto Merge text from multiple sources Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Tho component files would have to have the same name and be stored in the same location each month.
The parts to be captured would need to have a fixed bookmark name.

You would use an IncludeText field in your main document. Then:
  1. Store all of the component documents in the proper folder.
  2. Open your main document.
  3. Update all the IncludeText fields.
There likely are other methods, but this is the one I would use.


You may also want to explore: Boiler - Insert a selection of documents by Graham Mayor, MVP
Reply With Quote
  #3  
Old 06-01-2023, 04:12 PM
Guessed's Avatar
Guessed Guessed is offline Auto Merge text from multiple sources Windows 10 Auto Merge text from multiple sources Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
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

Do you have control of the content that is being emailed to you? You will need to have a robust method of 'tagging' the content being provided to you so that you can automate the retrieval of those components. If you can get good tagged input docs then you have a chance of automating the data compilation.

Charles' suggestion of tagging those input files with bookmarks is the 'correct' recommendation but in practice I would expect that your input providers will return documents with those bookmarks missing or the bookmarks won't contain the text you need. Because bookmarks are invisible and how they behave when people replace text in and around bookmarks you are going to need to check/repair each one to get good results with an includetext-based solution. In my mind, this is no better than the copy/paste method you already work with.

Instead, I would recommend putting Rich Text Content Controls into your source documents because those can be protected from deletion and CCs are more visible on screen for your content providers so they will find it easier to comply with your input requirements by putting the content INSIDE the marked places.

Using CCs to tag the input info doesn't lend itself to a simple method for compilation but that can then readily be automated with a macro or a workflow method.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Insert Text from external sources jtm4890 Word 2 10-25-2022 06:54 PM
Auto Merge text from multiple sources Mail Merge - Multiple Sources SQUiD Mail Merge 11 11-16-2020 06:27 PM
Mail merge with 2 sources Marcia Mail Merge 3 07-04-2020 09:38 PM
Mail merge - data sources Sarki76 Mail Merge 2 09-02-2019 01:28 AM
how auto-merge multiple word files upon change detected dylansmith Word 1 02-09-2018 11:37 PM

Other Forums: Access Forums

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


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