Macro will not run

[Matt]

I've got a bunch of Mail Merge Documents that use data from an Access DB.
The documents are grouped in folders based on the type of document. From a
form in access, when a button is clicked the correct word docs open. One of
the buttons makes 7 to 9 word docs open.
Each of the word docs has vb to make it merge automaticly then close the
template on Document_Open(). Two of the 7 to 9 documents sometimes (not
everytime) will not run the macro and will just open to the mail merge
template, they won't merge and close the template.

What could be the reason for this?

Thanks,

Matt

 

[Doug Robbins - Word MVP]

If the macros are executing the merge directly to the printer, modify the
code so that the Background printing option is off. If it's on, Word would
try and start merging the next document while the other one is still
printing and it might get overloaded.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Matt]

The macro just merges a soft copy:

Sub Startup()
Dim DocName$
DocName = ActiveDocument.Name
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With
Windows(DocName).Close wdDoNotSaveChanges
End Sub

I'd say 1 out of 10 times, one of the documents will not merge. There are
an average of 4 merges occuring at a time.

Thanks,
Matt