Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeat a merge if a record exists or end if it doesn't
Greetings,
I am trying to make a document in which my data source is a .txt document generated from an access query and exported. I want the document to look at the data source and list all of the records in the .txt document. But, when there is no longer any records to list, I want it to stop. Right now I have to put 40 different mrege record entires in to cover possible record entries from the query. Here is what I have now: «QuestionText» «AnswerText» Follow-up Action Taken/Required: «Next Record If»«QuestionText» «AnswerText» Follow-up Action Taken/Required: From Next Record If it is just repeated so that the form is looking for the next record. Basically if the next record answer text field has something listed, i want the question associated with the answer and the answer itself to come up. The Follow-up action taken/required needs to come up when there is an answer text merged from the query. If there aren't any more records i don't want nearly 3 pages of empty document. I am sorry if this doesn't make sense but I can try to clarify if needed. Any help you can offer is greatly appreciated |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeat a merge if a record exists or end if it doesn't
Use a Catalog (or in Word XP and later it is called Directory) type
mailmerge main document in which you have just «QuestionText» «AnswerText» Follow-up Action Taken/Required: When you execute that merge to a new document, that information will be repeated for each record in the data source. -- 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 "Jerkules" wrote in message ... Greetings, I am trying to make a document in which my data source is a .txt document generated from an access query and exported. I want the document to look at the data source and list all of the records in the .txt document. But, when there is no longer any records to list, I want it to stop. Right now I have to put 40 different mrege record entires in to cover possible record entries from the query. Here is what I have now: «QuestionText» «AnswerText» Follow-up Action Taken/Required: «Next Record If»«QuestionText» «AnswerText» Follow-up Action Taken/Required: From Next Record If it is just repeated so that the form is looking for the next record. Basically if the next record answer text field has something listed, i want the question associated with the answer and the answer itself to come up. The Follow-up action taken/required needs to come up when there is an answer text merged from the query. If there aren't any more records i don't want nearly 3 pages of empty document. I am sorry if this doesn't make sense but I can try to clarify if needed. Any help you can offer is greatly appreciated |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeat a merge if a record exists or end if it doesn't
I changed the document type to a directory and deleted the fields that i
would normally have repeated, but this time it only placed 1 record in the document, no others. "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge main document in which you have just «QuestionText» «AnswerText» Follow-up Action Taken/Required: When you execute that merge to a new document, that information will be repeated for each record in the data source. -- 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 "Jerkules" wrote in message ... Greetings, I am trying to make a document in which my data source is a .txt document generated from an access query and exported. I want the document to look at the data source and list all of the records in the .txt document. But, when there is no longer any records to list, I want it to stop. Right now I have to put 40 different mrege record entires in to cover possible record entries from the query. Here is what I have now: «QuestionText» «AnswerText» Follow-up Action Taken/Required: «Next Record If»«QuestionText» «AnswerText» Follow-up Action Taken/Required: From Next Record If it is just repeated so that the form is looking for the next record. Basically if the next record answer text field has something listed, i want the question associated with the answer and the answer itself to come up. The Follow-up action taken/required needs to come up when there is an answer text merged from the query. If there aren't any more records i don't want nearly 3 pages of empty document. I am sorry if this doesn't make sense but I can try to clarify if needed. Any help you can offer is greatly appreciated |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeat a merge if a record exists or end if it doesn't
nevermind...I just merged the data to a new document and it did what I want.
My next question: I want to place a heading on this document that only shows once. When I put anything on the merge document, it gets repeated. How can I make it show only once? "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge main document in which you have just «QuestionText» «AnswerText» Follow-up Action Taken/Required: When you execute that merge to a new document, that information will be repeated for each record in the data source. -- 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 "Jerkules" wrote in message ... Greetings, I am trying to make a document in which my data source is a .txt document generated from an access query and exported. I want the document to look at the data source and list all of the records in the .txt document. But, when there is no longer any records to list, I want it to stop. Right now I have to put 40 different mrege record entires in to cover possible record entries from the query. Here is what I have now: «QuestionText» «AnswerText» Follow-up Action Taken/Required: «Next Record If»«QuestionText» «AnswerText» Follow-up Action Taken/Required: From Next Record If it is just repeated so that the form is looking for the next record. Basically if the next record answer text field has something listed, i want the question associated with the answer and the answer itself to come up. The Follow-up action taken/required needs to come up when there is an answer text merged from the query. If there aren't any more records i don't want nearly 3 pages of empty document. I am sorry if this doesn't make sense but I can try to clarify if needed. Any help you can offer is greatly appreciated |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeat a merge if a record exists or end if it doesn't
Do it after executing the merge. I think fellow MVP Cindy Meister may have
some other approaches on her website at: http://homepage.swissonline.ch/cindymeister/ -- 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 "Jerkules" wrote in message ... nevermind...I just merged the data to a new document and it did what I want. My next question: I want to place a heading on this document that only shows once. When I put anything on the merge document, it gets repeated. How can I make it show only once? "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge main document in which you have just «QuestionText» «AnswerText» Follow-up Action Taken/Required: When you execute that merge to a new document, that information will be repeated for each record in the data source. -- 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 "Jerkules" wrote in message ... Greetings, I am trying to make a document in which my data source is a .txt document generated from an access query and exported. I want the document to look at the data source and list all of the records in the .txt document. But, when there is no longer any records to list, I want it to stop. Right now I have to put 40 different mrege record entires in to cover possible record entries from the query. Here is what I have now: «QuestionText» «AnswerText» Follow-up Action Taken/Required: «Next Record If»«QuestionText» «AnswerText» Follow-up Action Taken/Required: From Next Record If it is just repeated so that the form is looking for the next record. Basically if the next record answer text field has something listed, i want the question associated with the answer and the answer itself to come up. The Follow-up action taken/required needs to come up when there is an answer text merged from the query. If there aren't any more records i don't want nearly 3 pages of empty document. I am sorry if this doesn't make sense but I can try to clarify if needed. Any help you can offer is greatly appreciated |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Repeat a merge if a record exists or end if it doesn't
Thanks.
This is a great resource!! "Doug Robbins - Word MVP" wrote: Do it after executing the merge. I think fellow MVP Cindy Meister may have some other approaches on her website at: http://homepage.swissonline.ch/cindymeister/ -- 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 "Jerkules" wrote in message ... nevermind...I just merged the data to a new document and it did what I want. My next question: I want to place a heading on this document that only shows once. When I put anything on the merge document, it gets repeated. How can I make it show only once? "Doug Robbins - Word MVP" wrote: Use a Catalog (or in Word XP and later it is called Directory) type mailmerge main document in which you have just «QuestionText» «AnswerText» Follow-up Action Taken/Required: When you execute that merge to a new document, that information will be repeated for each record in the data source. -- 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 "Jerkules" wrote in message ... Greetings, I am trying to make a document in which my data source is a .txt document generated from an access query and exported. I want the document to look at the data source and list all of the records in the .txt document. But, when there is no longer any records to list, I want it to stop. Right now I have to put 40 different mrege record entires in to cover possible record entries from the query. Here is what I have now: «QuestionText» «AnswerText» Follow-up Action Taken/Required: «Next Record If»«QuestionText» «AnswerText» Follow-up Action Taken/Required: From Next Record If it is just repeated so that the form is looking for the next record. Basically if the next record answer text field has something listed, i want the question associated with the answer and the answer itself to come up. The Follow-up action taken/required needs to come up when there is an answer text merged from the query. If there aren't any more records i don't want nearly 3 pages of empty document. I am sorry if this doesn't make sense but I can try to clarify if needed. Any help you can offer is greatly appreciated |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on Mail Merge just only Show One Record | Mailmerge | |||
"Next Record If", Mail Merge Issues | Mailmerge | |||
Next Record If, problems with merging multiple records | Mailmerge | |||
mail merge screws up one record, others okay | Mailmerge | |||
sort mail merge by merge record number | Mailmerge |