Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reformatting a finished document | Microsoft Word Help | |||
How do I add a title page to a finished paper? | Microsoft Word Help | |||
Can't close Word due to send mail command not finished | Microsoft Word Help | |||
why does word cut me off before i have finished my document | New Users | |||
Track Changes in a finished document. | Microsoft Word Help |