Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-06-2011, 04:35 AM
obrienaj obrienaj is offline automating insertion of some text Windows XP automating insertion of some text Office 2010 32bit
Novice
automating insertion of some text
 
Join Date: Oct 2011
Posts: 2
obrienaj is on a distinguished road
Default automating insertion of some text

I'm looking to create a document where certain passages have the same text inserted and other passages are more individualized. Example.

1. Dave was here today

2. Dave was in a good mood

3. Dave said he was feeling good because he just won the lottery.

In the above example, "Dave" would be a name that changes . I would want to add the name of several people. 1 and two above would be the same sentence except for the name. However number 3 above would be an individualized paragraph that would be substantially different for each person. I'm looking to be able to quickly type in number three , print it, and move on to the next person.
Reply With Quote
  #2  
Old 10-07-2011, 01:47 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline automating insertion of some text Windows 7 64bit automating insertion of some text Office 2010 32bit
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

You are describing a mail merge. For more, see this article:

Use mail merge to create and print letters and other documents
http://office.microsoft.com/en-us/wo...701.aspx?CTT=1
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #3  
Old 10-17-2011, 11:37 AM
obrienaj obrienaj is offline automating insertion of some text Windows XP automating insertion of some text Office 2010 32bit
Novice
automating insertion of some text
 
Join Date: Oct 2011
Posts: 2
obrienaj is on a distinguished road
Default

Thanks. I have made some progress and can now do most of what I wanted to do. The main thing I am stuck on is how to use a document that already exists , already has merged fields placed in it, and run again from the same excel file (with same field names).

For example, if I have a document that looks like

had a little whose fleece was white as .


and I added merge fields as indicated below

«First_Name» had a little «Animal» whose fleece was white as «Substance»


After I have run this mail merge and a week later want to run it again, how can I use it without having to again select the merge fields? If I pull up the document used a week ago, it seems to populate from the previously completed merge, I want to run the same mail merge with same fields but updated contents from the excel sheet.
Reply With Quote
  #4  
Old 10-17-2011, 11:50 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline automating insertion of some text Windows 7 64bit automating insertion of some text Office 2010 32bit
Moderator
 
Join Date: Aug 2011
Posts: 3,907
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Hmm, since the data source has been updated, you should be seeing the correct data when you complete the merge. What displays in the "main" document (to which the merge source is attached) when you open it is not a reflection on the result of the merge.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
automating insertion of some text wildly flashing insertion point with spinning wheel joannetk Word 4 03-10-2011 04:26 AM
Automating document updates with new text wordfoolish2 Word 0 01-04-2011 01:01 PM
Automatic insertion of blank pages or alternate text Diopippo Word 0 07-06-2010 12:13 AM
Automating Cel Population of .jpg skoz55 Excel 0 01-21-2009 03:43 AM
special/escape/insertion characters in word manojbmsce Word 0 09-25-2008 06:40 AM

Other Forums: Access Forums

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


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