Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2018, 08:10 AM
sunrise06 sunrise06 is offline Send Mailmerge Output to Individual Files - Help Needed Windows 7 64bit Send Mailmerge Output to Individual Files - Help Needed Office 2013
Novice
Send Mailmerge Output to Individual Files - Help Needed
 
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 (https://www.msofficeforums.com/mail-...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 offline Send Mailmerge Output to Individual Files - Help Needed Windows 7 64bit Send Mailmerge Output to Individual Files - Help Needed Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Hmm, somehow that macro lost its:
.Execute Pause:=False
before:
If Err.Number = 5631 Then
Fixed. Try it with that line.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-22-2018, 07:45 PM
sunrise06 sunrise06 is offline Send Mailmerge Output to Individual Files - Help Needed Windows 7 64bit Send Mailmerge Output to Individual Files - Help Needed Office 2013
Novice
Send Mailmerge Output to Individual Files - Help Needed
 
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 offline Send Mailmerge Output to Individual Files - Help Needed Windows 7 64bit Send Mailmerge Output to Individual Files - Help Needed Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Only by hiding the Word window while the macro runs - but then there's no telling what will be displayed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 12-22-2018, 07:56 PM
sunrise06 sunrise06 is offline Send Mailmerge Output to Individual Files - Help Needed Windows 7 64bit Send Mailmerge Output to Individual Files - Help Needed Office 2013
Novice
Send Mailmerge Output to Individual Files - Help Needed
 
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
Send Mailmerge Output to Individual Files - Help Needed Send Mailmerge Output to Individual Files - Help with VBA plupton Mail Merge 2 12-24-2019 07:18 AM
Send Mailmerge Output to Individual Files - Help Needed 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 Needed 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 - Help Needed Send Mailmerge Output to Individual Files - troubleshooting help mxk372 Mail Merge 1 07-06-2017 03:49 PM
Send Mailmerge Output to Individual Files - Help Needed Mailmerge Individual Documents DaddyMac Mail Merge 4 06-06-2013 09:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:20 PM.


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