Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2016, 07:10 AM
neilclelland neilclelland is offline Log file for mail merge Windows 8 Log file for mail merge Office 2007
Novice
Log file for mail merge
 
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 Log file for mail merge Windows 7 64bit Log file for mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-08-2016, 03:45 AM
neilclelland neilclelland is offline Log file for mail merge Windows 8 Log file for mail merge Office 2007
Novice
Log file for mail merge
 
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 Log file for mail merge Windows 7 64bit Log file for mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You will have to ask the creators of whichever plugin you're using.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-08-2016, 04:08 AM
neilclelland neilclelland is offline Log file for mail merge Windows 8 Log file for mail merge Office 2007
Novice
Log file for mail merge
 
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 Log file for mail merge Windows 7 64bit Log file for mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 12-08-2016, 09:05 AM
neilclelland neilclelland is offline Log file for mail merge Windows 8 Log file for mail merge Office 2007
Novice
Log file for mail merge
 
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 Log file for mail merge Windows 7 64bit Log file for mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
excel 2007, log file, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Log file for mail merge 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
Log file for mail merge Creating separate file for each mail merge doshshirl Mail Merge 3 02-15-2014 08:49 PM
Log file for mail merge Word Mail Merge File Save mickeyw3340 Mail Merge 2 12-18-2012 11:30 AM
Log file for mail merge how do i ad a specific pdf file to a mail merge? mseibel Mail Merge 1 08-28-2012 07:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft