Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-05-2016, 07:10 AM
neilclelland neilclelland is offline Windows 8 Office 2007
Novice
 
Join Date: Dec 2016
Posts: 4
neilclelland is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-05-2016, 04:00 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,631
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-08-2016, 03:45 AM
neilclelland neilclelland is offline Windows 8 Office 2007
Novice
 
Join Date: Dec 2016
Posts: 4
neilclelland is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 12-08-2016, 04:06 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,631
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You will have to ask the creators of whichever plugin you're using.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 12-08-2016, 04:08 AM
neilclelland neilclelland is offline Windows 8 Office 2007
Novice
 
Join Date: Dec 2016
Posts: 4
neilclelland is on a distinguished road
Default

So mail merge does not produce a log file?
Reply With Quote
  #6  
Old 12-08-2016, 04:24 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,631
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #7  
Old 12-08-2016, 09:05 AM
neilclelland neilclelland is offline Windows 8 Office 2007
Novice
 
Join Date: Dec 2016
Posts: 4
neilclelland is on a distinguished road
Default

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...............
Reply With Quote
  #8  
Old 12-08-2016, 03:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,631
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Tags
excel 2007, log file, mail merge
Please reply to this thread with any new information or opinions.

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


All times are GMT -7. The time now is 01:17 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft