[Mushinma]

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