[Mushinma]

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!!!