Home |
Search |
Today's Posts |
#1
|
|||
|
|||
You can wrap the number/sentence info with bookmarks. Then...in the
content doc, click Insert Field IncludeText and insert the name of the file and bookmark for the content you want dropped into this location. When you change the number/sentence info in the one doc, you can open the other doc and update the info...either manually, or automatically if you set Tools Options General and choose to update links at open. As for passing the info around the content doc in more than one location...wrap the IncludeText field with another bookmark and then you can click Insert Field REF to include a reference to that original bookmark location. That will cause the included content to go into the main spot, but also be passed around throughout the doc in the other locations you need. For some further info on the second step, see this link: http://www.mousetrax.com/TechPage.html#autoforms There you'll find a link to an article called: Pass Repeated Information in a Word Document Dian D. Chapman, Technical Consultant Microsoft MVP, MOS Certified Editor/TechTrax Ezine Free MS Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: http://www.mousetrax.com/books.html Optimize your business docs: http://www.mousetrax.com/consulting Learn VBA the easy way: http://www.mousetrax.com/techcourses.html On Tue, 17 May 2005 20:56:05 -0400, "Steve" wrote: I woulds appreciate some direction. I have a large word 2003 document with 300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve |
#2
|
|||
|
|||
Help - Updating a document
I woulds appreciate some direction. I have a large word 2003 document with
300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve |
#3
|
|||
|
|||
Steve,
What you are asking is very possible. I do need a little more information though. But the first thing I thought of was hyperlinks, you can basically hyperlink to just about anything in the world and from one point in the document to the other. I would also consider using Excel for you document that is using two columns, one being numbers and the other being text. Remember you can have the Excel document print out just like it does in Word. Also with Excel, when data or text is one cell and if you were typing that same data or text in another cell, it pops right in there for you so that you do not have to retype it. Sort of like Auto Correct does in Word, and on that note, you can also add a lot of the text that is being repeated to Auto Correct, just highlight it and add to the Auto Correct. And going back to Excel, you can create formulas so that if one cell equals something it can go to wherever the formula is pointing and so on. Hope this helps. -- Top Notch Admin "Steve" wrote: I woulds appreciate some direction. I have a large word 2003 document with 300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve |
#4
|
|||
|
|||
An IncludeText field will pull text from a different document, and the field
can be updated to match text changed in the other document. Start by looking it up in Help, post back if you run into problems. On 5/17/05 5:56 PM, "Steve" wrote: I woulds appreciate some direction. I have a large word 2003 document with 300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
#5
|
|||
|
|||
My first thought was IncludeText but other options include document
properties (inserted via DocProperty fields), document variables (which require VBA), and AutoText fields. AutoText entries can't be updated--they have to be recreated--but AutoText fields are certainly easy to insert. If you do choose to use IncludeText fields, note that you will need to bookmark each chunk of text; you can then insert the field using Insert | File, selecting the bookmark as the "range." But when you replace the text in your master file, you may need to reapply the bookmark. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Daiya Mitchell" wrote in message .. . An IncludeText field will pull text from a different document, and the field can be updated to match text changed in the other document. Start by looking it up in Help, post back if you run into problems. On 5/17/05 5:56 PM, "Steve" wrote: I woulds appreciate some direction. I have a large word 2003 document with 300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
#6
|
|||
|
|||
Well I'm getting closer, I saved my master as an excel file. I inserted the
IncludeText field with the path to the excel master. And it inserts the entire file. How do I tell it I want only the text from cell B41 without any format carry over? "Daiya Mitchell" wrote in message .. . An IncludeText field will pull text from a different document, and the field can be updated to match text changed in the other document. Start by looking it up in Help, post back if you run into problems. On 5/17/05 5:56 PM, "Steve" wrote: I woulds appreciate some direction. I have a large word 2003 document with 300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
#7
|
|||
|
|||
Why did you save it as an excel file? That's not necessary. You can do all
this in Word. (the guy who suggested excel was wrong) See Suzanne's post about bookmarking each chunk of text. On 5/18/05 9:30 AM, "Steve" wrote: Well I'm getting closer, I saved my master as an excel file. I inserted the IncludeText field with the path to the excel master. And it inserts the entire file. How do I tell it I want only the text from cell B41 without any format carry over? "Daiya Mitchell" wrote in message .. . An IncludeText field will pull text from a different document, and the field can be updated to match text changed in the other document. Start by looking it up in Help, post back if you run into problems. On 5/17/05 5:56 PM, "Steve" wrote: I woulds appreciate some direction. I have a large word 2003 document with 300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve |
#8
|
|||
|
|||
Sorry...I rarely use Excel these days...so I don't know how to do it
with Excel included...just Word to Word as previously explained. Good luck... Dian ~ On Wed, 18 May 2005 12:30:06 -0400, "Steve" wrote: Well I'm getting closer, I saved my master as an excel file. I inserted the IncludeText field with the path to the excel master. And it inserts the entire file. How do I tell it I want only the text from cell B41 without any format carry over? "Daiya Mitchell" wrote in message . .. An IncludeText field will pull text from a different document, and the field can be updated to match text changed in the other document. Start by looking it up in Help, post back if you run into problems. On 5/17/05 5:56 PM, "Steve" wrote: I woulds appreciate some direction. I have a large word 2003 document with 300 plus pages requiring weekly updates. Spread within the large document are many technical sentences (could be as much as a paragraph) which change wording and/or number values. I have a second document, which I call a master, I have a simple two column word table with about 120 rows. Column 1 is just a row number, column two is the technical sentence. What I need to set up is a way to insert a code of some type in the large document so that the sentences are replaced from this table (I could just as easy use an excel sheet if that would be easier). What I need to do is after I update the table, then somehow update the large document with the new sentences. I should add, the large document is not a boilerplate type so a word template mailmerge does not seem to fit the case. Also, the sentences in my master appear at random and often repeat themselves in the large document. Steve -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
#9
|
|||
|
|||
OOOOOOOOKKKKKKK, back to word... And the word table, if I understand this
correctly, in the master document I bookmark the contains of each cell in column two (120 or so). And in the Large document I insert the IncludeText field with the path/file name and the specific bookmark name. The reason I jumped on excel was that I thought I might bypass the manual bookmark process by using the cell location, i.e., B2, B15 etc... It works to a degree, but it insert a single cell table, not the contents of the cell to be used in normal sentence structure. Also, that's the way I receive my updates, our access database generates an excel spreadsheet which I copy over to a word table for ease of use to cut & paste to my large document. It would cut that extra step out and make life sweeter... Steve "Dian D. Chapman, MVP" wrote in message ... Sorry...I rarely use Excel these days...so I don't know how to do it with Excel included...just Word to Word as previously explained. Good luck... Dian ~ On Wed, 18 May 2005 12:30:06 -0400, "Steve" wrote: Well I'm getting closer, I saved my master as an excel file. I inserted the IncludeText field with the path to the excel master. And it inserts the entire file. How do I tell it I want only the text from cell B41 without any format carry over? |
#10
|
|||
|
|||
"Dian D. Chapman, MVP" wrote: Yup...that's it. By the way...if this info is in Access...you CAN just link your doc right to the specific data in Access through ADO. Then when you open your document, the data would be pulled right from Access. Granted, this takes some knowledge of VBA...but I just wanted to pass that along so you know there IS a more direct way if that might work for you. In fact, using the same technology, you can even do that to Excel if you code it as links. I don't know if this will fit what you're doing, since I don't understand your whole process, but I do this all the time with documents and forms. Say you get data each month or whatever and it's fairly consistant...you could set up the Word doc to allow you to type in some range and that'll query the DB, pull that data and enter it into the specific locations. Just a though. Note that if you want to see how this words...I have a sample with open code for ADO. Go he http://www.mousetrax.com/techpage.html#autoforms and scroll down to the # 5 article in the Please Fill Out This Form series. Download the sample and mess with it as per the article and instructions for the download. It should you how you can enter info into a form and have it passed to a DB without retyping...or pull data from a DB to populate a form. Good luck... Dian D. Chapman, Technical Consultant Microsoft MVP, MOS Certified Editor/TechTrax Ezine Free MS Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: http://www.mousetrax.com/books.html Optimize your business docs: http://www.mousetrax.com/consulting Learn VBA the easy way: http://www.mousetrax.com/techcourses.html On Thu, 19 May 2005 08:35:09 -0400, "Steve" wrote: OOOOOOOOKKKKKKK, back to word... And the word table, if I understand this correctly, in the master document I bookmark the contains of each cell in column two (120 or so). And in the Large document I insert the IncludeText field with the path/file name and the specific bookmark name. The reason I jumped on excel was that I thought I might bypass the manual bookmark process by using the cell location, i.e., B2, B15 etc... It works to a degree, but it insert a single cell table, not the contents of the cell to be used in normal sentence structure. Also, that's the way I receive my updates, our access database generates an excel spreadsheet which I copy over to a word table for ease of use to cut & paste to my large document. It would cut that extra step out and make life sweeter... Steve "Dian D. Chapman, MVP" wrote in message .. . Sorry...I rarely use Excel these days...so I don't know how to do it with Excel included...just Word to Word as previously explained. Good luck... Dian ~ On Wed, 18 May 2005 12:30:06 -0400, "Steve" wrote: Well I'm getting closer, I saved my master as an excel file. I inserted the IncludeText field with the path to the excel master. And it inserts the entire file. How do I tell it I want only the text from cell B41 without any format carry over? |
#11
|
|||
|
|||
Yup...that's it.
By the way...if this info is in Access...you CAN just link your doc right to the specific data in Access through ADO. Then when you open your document, the data would be pulled right from Access. Granted, this takes some knowledge of VBA...but I just wanted to pass that along so you know there IS a more direct way if that might work for you. In fact, using the same technology, you can even do that to Excel if you code it as links. I don't know if this will fit what you're doing, since I don't understand your whole process, but I do this all the time with documents and forms. Say you get data each month or whatever and it's fairly consistant...you could set up the Word doc to allow you to type in some range and that'll query the DB, pull that data and enter it into the specific locations. Just a though. Note that if you want to see how this words...I have a sample with open code for ADO. Go he http://www.mousetrax.com/techpage.html#autoforms and scroll down to the # 5 article in the Please Fill Out This Form series. Download the sample and mess with it as per the article and instructions for the download. It should you how you can enter info into a form and have it passed to a DB without retyping...or pull data from a DB to populate a form. Good luck... Dian D. Chapman, Technical Consultant Microsoft MVP, MOS Certified Editor/TechTrax Ezine Free MS Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: http://www.mousetrax.com/books.html Optimize your business docs: http://www.mousetrax.com/consulting Learn VBA the easy way: http://www.mousetrax.com/techcourses.html On Thu, 19 May 2005 08:35:09 -0400, "Steve" wrote: OOOOOOOOKKKKKKK, back to word... And the word table, if I understand this correctly, in the master document I bookmark the contains of each cell in column two (120 or so). And in the Large document I insert the IncludeText field with the path/file name and the specific bookmark name. The reason I jumped on excel was that I thought I might bypass the manual bookmark process by using the cell location, i.e., B2, B15 etc... It works to a degree, but it insert a single cell table, not the contents of the cell to be used in normal sentence structure. Also, that's the way I receive my updates, our access database generates an excel spreadsheet which I copy over to a word table for ease of use to cut & paste to my large document. It would cut that extra step out and make life sweeter... Steve "Dian D. Chapman, MVP" wrote in message .. . Sorry...I rarely use Excel these days...so I don't know how to do it with Excel included...just Word to Word as previously explained. Good luck... Dian ~ On Wed, 18 May 2005 12:30:06 -0400, "Steve" wrote: Well I'm getting closer, I saved my master as an excel file. I inserted the IncludeText field with the path to the excel master. And it inserts the entire file. How do I tell it I want only the text from cell B41 without any format carry over? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you save individual document pages as seperate word files? | Mailmerge | |||
See the document map when the document is split in two panes. | Microsoft Word Help | |||
Remembering initial caps set in a document | New Users | |||
Auto Updating TOC in Protected Form | Microsoft Word Help | |||
Word 2000 - Document 1 and Document 2 always open on startup | Microsoft Word Help |