Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-22-2018, 08:10 AM
sunrise06 sunrise06 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2015
Posts: 9
sunrise06 is on a distinguished road
Question Send Mailmerge Output to Individual Files - Help Needed

I found the post - Send Mailmerge Output to Individual Files (http://www.msofficeforums.com/mail-m...ps-tricks.html) however I am getting an error.

I got it to run originally but the output was just the field names, not the merged data so I CTRL-ALT-DELETED Word to stop the process. Once I determined I needed to be in preview mode, it will only complete one record and then I get a Run-Time Error 5825. Any suggestion on how to fix this error?

Thanks!
Reply With Quote
  #2  
Old 12-22-2018, 07:39 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,098
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 beholdmacropod is a splendid one to behold
Default

Hmm, somehow that macro lost its:
.Execute Pause:=False
before:
If Err.Number = 5631 Then
Fixed. Try it with that line.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-22-2018, 07:45 PM
sunrise06 sunrise06 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2015
Posts: 9
sunrise06 is on a distinguished road
Default

Awesome, thank you! I did, however, notice the screen flash for each file. Is there a way to hide that?
Reply With Quote
  #4  
Old 12-22-2018, 07:53 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,098
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 beholdmacropod is a splendid one to behold
Default

Only by hiding the Word window while the macro runs - but then there's no telling what will be displayed.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 12-22-2018, 07:56 PM
sunrise06 sunrise06 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2015
Posts: 9
sunrise06 is on a distinguished road
Default

Thanks for your help today! Much appreciated!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to name a pdf output with Word 2016 mailmerge jbulldog Mail Merge 3 02-05-2018 12:49 PM
Send Mailmerge Output to Individual Files - Help with VBA plupton Mail Merge 1 01-10-2018 10:22 PM
Save mailmerge records as individual word files using VBA beefcake2000 Word VBA 3 11-10-2017 09:55 PM
Send Mailmerge Output to Individual Files - troubleshooting help mxk372 Mail Merge 1 07-06-2017 03:49 PM
Mailmerge Individual Documents DaddyMac Mail Merge 4 06-06-2013 09:22 PM


All times are GMT -7. The time now is 04:03 PM.


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