#1
|
|||
|
|||
Log file for mail merge
Hi,
I am running a very large mail merge with around 20,000 records and grouping by order number. The mail merge runs fine from Excel populating the fields in PDF files. But, I would like to QC the results in a smart way, and I think that reviewing some sort of log file of the mail merge would enable me to do this. However, I can't find any such log file or an option to save the log? If anyone knows how to get/create a log file, or a smarter way to QC the files produced so I can be sure the process has run correctly Thanks in advance Neil |
#2
|
||||
|
||||
What would the log file contain - a list of the records? Unless you're using filtering, that's what your data source already contains. And how would you propose to use if for QC purposes? If records are skipped in error, any log file produced by the same merge process would be expected to skip those records too, with the result that you'd end up comparing an erroneous log against its equally erroneous output.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I am using the mail merge with 'many to one' plugin. The mail merge is separated by order number.
So I would assume the log file would contain details of numbers of records merged in each order number. Is there a log file produced? If a log file is produced per merge then I can compare the text file against my own log of individual orders. At the moment I just want to know if a log file is produced? |
#4
|
||||
|
||||
You will have to ask the creators of whichever plugin you're using.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
So mail merge does not produce a log file?
|
#6
|
||||
|
||||
No - otherwise you'd have encountered one before now. Besides which, it seems you still haven't grasped the idea that a log file would likely only show the same set of records as appear in the merged output. If that's all you want, you could run a simple directory merge using the same query parameters and just the mergefields you want to appear in the log. It's up to you how much reliance you'll place on such a log when it will invariably return the same (in)correct results as the merge you're trying to log.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
I have grasped the idea fine thank you!
There are several ways in which the original excel input data can be compared to a log file. The whole point is that the log file would show the same as is output! But compared against the original input data that is where the errors would be highlighted! But given that no log file is produced or there is no option to produce a log file............... |
#8
|
||||
|
||||
A log file can only tell you what was produced, not what should have been produced. The mere fact it may not match the data source is only indicative of errors if you know that all those data should have been included. Given that mailmerge outputs are often filtered in various ways, having a file that only tells you what got output is but a small part of the story. Any mailmerge output is its own log file in that sense.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
excel 2007, log file, mail merge |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Appending a mail merge document to a static file | svo | Mail Merge | 5 | 06-18-2015 05:17 AM |
Printing a Mail Merge output file | Ar-Pharazon | Mail Merge | 7 | 09-13-2014 07:11 AM |
Creating separate file for each mail merge | doshshirl | Mail Merge | 3 | 02-15-2014 08:49 PM |
Word Mail Merge File Save | mickeyw3340 | Mail Merge | 2 | 12-18-2012 11:30 AM |
how do i ad a specific pdf file to a mail merge? | mseibel | Mail Merge | 1 | 08-28-2012 07:53 PM |