Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Outcome Validation
I mail-merged 10 records of source data from MS Excel 2003 into an one page
MS Word 2003 template. The mail merge completed sucessfully with a 10-page outcome Word file containing all records from the merge. My question is: is there a way I can compare the merged data in the final Word document with the original Excel data? In other words, if I have firstName: A, B, C in the source Excel file, I want to know whether after the mail merge value A, B, C is in the merged document with the exact value and order as original. Thanks in advance!!! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Outcome Validation
Most people have better things to do. The only way to do it would be to
physically compare the data in Excel source with that in the document. -- 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 "Mushinma" wrote in message ... I mail-merged 10 records of source data from MS Excel 2003 into an one page MS Word 2003 template. The mail merge completed sucessfully with a 10-page outcome Word file containing all records from the merge. My question is: is there a way I can compare the merged data in the final Word document with the original Excel data? In other words, if I have firstName: A, B, C in the source Excel file, I want to know whether after the mail merge value A, B, C is in the merged document with the exact value and order as original. Thanks in advance!!! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Outcome Validation
The reason for this exercise is to fulfill some audit control purposes. The
current process in place is Person A performs the mail merge and then Person B spot checks the mail merge result with original Excel data source. However, a lot of time, the data to be merged could be large (up to 1000 separate records), which makes the spot check really time consuming and cumbersome. -- Learning InfoPath "Doug Robbins - Word MVP" wrote: Most people have better things to do. The only way to do it would be to physically compare the data in Excel source with that in the document. -- 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 "Mushinma" wrote in message ... I mail-merged 10 records of source data from MS Excel 2003 into an one page MS Word 2003 template. The mail merge completed sucessfully with a 10-page outcome Word file containing all records from the merge. My question is: is there a way I can compare the merged data in the final Word document with the original Excel data? In other words, if I have firstName: A, B, C in the source Excel file, I want to know whether after the mail merge value A, B, C is in the merged document with the exact value and order as original. Thanks in advance!!! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Outcome Validation
I do not think that there is any other way of achieving the result. Have
you ever found a discrepancy between the merged output and the data in Excel? -- 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 "Mushinma" wrote in message ... The reason for this exercise is to fulfill some audit control purposes. The current process in place is Person A performs the mail merge and then Person B spot checks the mail merge result with original Excel data source. However, a lot of time, the data to be merged could be large (up to 1000 separate records), which makes the spot check really time consuming and cumbersome. -- Learning InfoPath "Doug Robbins - Word MVP" wrote: Most people have better things to do. The only way to do it would be to physically compare the data in Excel source with that in the document. -- 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 "Mushinma" wrote in message ... I mail-merged 10 records of source data from MS Excel 2003 into an one page MS Word 2003 template. The mail merge completed sucessfully with a 10-page outcome Word file containing all records from the merge. My question is: is there a way I can compare the merged data in the final Word document with the original Excel data? In other words, if I have firstName: A, B, C in the source Excel file, I want to know whether after the mail merge value A, B, C is in the merged document with the exact value and order as original. Thanks in advance!!! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Outcome Validation
Thanks for getting back to me. I have not found any discrepancy between the
mail merge result and source data. However, there might be opportunities for human manipulation after the mail merge. for instance, change Number A to Number B in Word doc We are trying to do a final comparison before the mail merge document become effective to catch the manipulation that has been done to it to eliminate any error. -- Learning InfoPath "Doug Robbins - Word MVP" wrote: I do not think that there is any other way of achieving the result. Have you ever found a discrepancy between the merged output and the data in Excel? -- 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 "Mushinma" wrote in message ... The reason for this exercise is to fulfill some audit control purposes. The current process in place is Person A performs the mail merge and then Person B spot checks the mail merge result with original Excel data source. However, a lot of time, the data to be merged could be large (up to 1000 separate records), which makes the spot check really time consuming and cumbersome. -- Learning InfoPath "Doug Robbins - Word MVP" wrote: Most people have better things to do. The only way to do it would be to physically compare the data in Excel source with that in the document. -- 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 "Mushinma" wrote in message ... I mail-merged 10 records of source data from MS Excel 2003 into an one page MS Word 2003 template. The mail merge completed sucessfully with a 10-page outcome Word file containing all records from the merge. My question is: is there a way I can compare the merged data in the final Word document with the original Excel data? In other words, if I have firstName: A, B, C in the source Excel file, I want to know whether after the mail merge value A, B, C is in the merged document with the exact value and order as original. Thanks in advance!!! |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Outcome Validation
Execute the merge directly to a printer and then the user will not have the
opportunity to change anything, or use the addin that you can down load from http://www.gmayor.com/individual_merge_letters.htm and execute the merge to separate .pdf files rather that Word documents. But, if a user is likely to change the result of a merge, aren't they as likely to change 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 "Mushinma" wrote in message ... Thanks for getting back to me. I have not found any discrepancy between the mail merge result and source data. However, there might be opportunities for human manipulation after the mail merge. for instance, change Number A to Number B in Word doc We are trying to do a final comparison before the merge document become effective to catch the manipulation that has been done to it to eliminate any error. -- Learning InfoPath "Doug Robbins - Word MVP" wrote: I do not think that there is any other way of achieving the result. Have you ever found a discrepancy between the merged output and the data in Excel? -- 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 "Mushinma" wrote in message ... The reason for this exercise is to fulfill some audit control purposes. The current process in place is Person A performs the mail merge and then Person B spot checks the mail merge result with original Excel data source. However, a lot of time, the data to be merged could be large (up to 1000 separate records), which makes the spot check really time consuming and cumbersome. -- Learning InfoPath "Doug Robbins - Word MVP" wrote: Most people have better things to do. The only way to do it would be to physically compare the data in Excel source with that in the document. -- 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 "Mushinma" wrote in message ... I mail-merged 10 records of source data from MS Excel 2003 into an one page MS Word 2003 template. The mail merge completed sucessfully with a 10-page outcome Word file containing all records from the merge. My question is: is there a way I can compare the merged data in the final Word document with the original Excel data? In other words, if I have firstName: A, B, C in the source Excel file, I want to know whether after the mail merge value A, B, C is in the merged document with the exact value and order as original. Thanks in advance!!! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Microsoft Word Help | |||
Address validation and verification | Microsoft Word Help | |||
address validation software | Microsoft Word Help | |||
validation help | New Users | |||
what is "address validation software" ? | Microsoft Word Help |