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



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 02:00 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