Thread Tools Display Modes
  #1   Report Post  
GarryB66 GarryB66 is offline
Junior Member
Posts: 1
Default Mail merge - how do I know it has finished?

I am kicking off a Word Mail Merge from an Excel macro.
The code looks like this -

With objDoc.MailMerge
.Destination = wdSendToNewDocument
.MainDocumentType = wdFormLetters
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With

This works well. However the mail merge may take a few minutes and I need to know when it has finished so that the macro can save and close the newly-created file (called something like "Letters1").

I notice that when you do the mail merge in Word there seems to be no notification that it has finished, you can only tell by watching the little icon at the bottom.

Can anyone help? Am I trying to do something that is impossible?
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reformatting a finished document durf Microsoft Word Help 1 February 1st 12 03:58 AM
How do I add a title page to a finished paper? eeoe Microsoft Word Help 1 December 2nd 08 04:14 AM
Can't close Word due to send mail command not finished stillbill Microsoft Word Help 0 January 20th 06 03:02 AM
why does word cut me off before i have finished my document whippetwad New Users 2 October 21st 05 12:48 AM
Track Changes in a finished document. MD Microsoft Word Help 3 May 17th 05 08:43 PM

All times are GMT +1. The time now is 05:22 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"