Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2018, 07:08 PM
eduzs eduzs is offline Mail merge to individual files, there's any kind of progress indicator Windows 10 Mail merge to individual files, there's any kind of progress indicator Office 2010 32bit
Expert
Mail merge to individual files, there's any kind of progress indicator
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default Mail merge to individual files, there's any kind of progress indicator

Based on the codes in https://www.msofficeforums.com/mail-...ps-tricks.html
While generating the mail merge individual files, is there a way to insert a progress bar or anything else besides watching windows blinking until the whole process is done?
Thanks.
Reply With Quote
  #2  
Old 08-31-2018, 08:17 PM
macropod's Avatar
macropod macropod is offline Mail merge to individual files, there's any kind of progress indicator Windows 7 64bit Mail merge to individual files, there's any kind of progress indicator 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

Yes. For example, after:
Application.ScreenUpdating = False
insert:
Code:
Dim SBar As Boolean
' Store current Status Bar status, then switch on
SBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Before:
On Error Resume Next
insert:
Code:
StatusBar = "Processing Record: " & i
And before:
Application.ScreenUpdating = True
insert:
Code:
' Clear the Status Bar
Application.StatusBar = False
' Restore original Status Bar status
Application.DisplayStatusBar = SBar
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-31-2018, 08:26 PM
gmayor's Avatar
gmayor gmayor is offline Mail merge to individual files, there's any kind of progress indicator Windows 10 Mail merge to individual files, there's any kind of progress indicator Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You could use http://www.gmayor.com/MergeAndSplit.htm or http://www.gmayor.com/individual_merge_letters.htm

both have progress indicators.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #4  
Old 08-31-2018, 08:46 PM
eduzs eduzs is offline Mail merge to individual files, there's any kind of progress indicator Windows 10 Mail merge to individual files, there's any kind of progress indicator Office 2010 32bit
Expert
Mail merge to individual files, there's any kind of progress indicator
 
Join Date: May 2017
Posts: 260
eduzs is on a distinguished road
Default

Thanks macropod and gmayor,
I think the "problem" is the statement "Destination = wdSendToNewDocument" makes screenupdating = true useless.
I could not see only the main window and the status bar (each new document flashes (appears and disappears) a MS Word window).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge to individual files, there's any kind of progress indicator Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs Btop Word VBA 26 03-07-2018 01:45 PM
Mail merge to individual files, there's any kind of progress indicator Mail Merge Word.doc to Individual Pages in PDF cmpmd2 Word VBA 2 06-16-2016 08:59 PM
Mail merge to individual files, there's any kind of progress indicator Mail Merge individual attachments + email Lewis.Mills Mail Merge 2 04-14-2016 10:11 PM
Can you have Individual Text in a Mail Merge SiberianBreaks21 Mail Merge 1 07-25-2014 05:01 PM
Mail merge to individual files, there's any kind of progress indicator Mail Merge To Individual PDF Files iamrickdeans Mail Merge 1 01-15-2014 12:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:48 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