Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge into middle of Word doc - non-repeating text
I am using Word & Excel 2000. I need to merge records from an Excel
file into the middle of a word document. I need to run this every day. The problem I am having is that I cannot figure out how to get the mail merge function to _not_ repeat the text I only want appearing above and below the repeating data. As an example of what I want: ___ Today's results are in for eveyone who ran the 100 yard dash. Here is the list and the times for each runner. [repeating data begins] Name: name Time: time [end repeating data] We will post the results every day as soon as we get them from the coach. Thanks. ____ How can I do this efficiently with Wod and Excel? Can it be done? Thanks. -- Jesse |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge into middle of Word doc - non-repeating text
You are trying to perform what amounts to a "multiple items per condition
(=key field)" mailmerge which Word does not really have the ability to do. The easiest thing is probably just to copy and paste the information from Excel in the Word document. However see the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article: http://support.microsoft.com/default...b;en-us;211303 or look at: http://www.knowhow.com/Guides/Compou...poundMerge.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Jesse" wrote in message ... I am using Word & Excel 2000. I need to merge records from an Excel file into the middle of a word document. I need to run this every day. The problem I am having is that I cannot figure out how to get the mail merge function to _not_ repeat the text I only want appearing above and below the repeating data. As an example of what I want: ___ Today's results are in for eveyone who ran the 100 yard dash. Here is the list and the times for each runner. [repeating data begins] Name: name Time: time [end repeating data] We will post the results every day as soon as we get them from the coach. Thanks. ____ How can I do this efficiently with Wod and Excel? Can it be done? Thanks. -- Jesse |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merge into middle of Word doc - non-repeating text
Thanks very much for the help. It is always good to know that a
direct solution is _not_ available -- so I can stop looking in Word 2000. The links were helpful and gave me some ideas. It would seem that I could insert my top text (before the merged data from the db) with an IF statement testing for MERGESEQ=1. Do you know if there is a length limit to a results text string in an IF statement? Also, is there a way to get a carriage return into the text string? Unfortunately, I could not find a way to test for the last record -- so I could say: IF last record, print "text". If I am wrong about testing for the last record, please let me know. Ultimately, maybe the easiest answer for my specific situation is to create a macro to insert the top-of-doc and end-of-doc text blocks after running the merge. One more button to push. Again, thanks. -- Jesse On Sun, 16 Jul 2006 07:45:35 +0200, "Doug Robbins - Word MVP" wrote: You are trying to perform what amounts to a "multiple items per condition (=key field)" mailmerge which Word does not really have the ability to do. The easiest thing is probably just to copy and paste the information from Excel in the Word document. However see the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at: http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article: http://support.microsoft.com/default...b;en-us;211303 or look at: http://www.knowhow.com/Guides/Compou...poundMerge.htm |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Word applies direct format on File open | Microsoft Word Help |