Macro will not run

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 09 Feb 2006 22:02 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 10 Feb 2006 05:11 GMT

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.

Signature

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

> 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
[quoted text clipped - 12 lines]
>
> Matt

Reply to this Message

Matt - 13 Feb 2006 15:24 GMT

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

> 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
[quoted text clipped - 17 lines]
> >
> > Matt

Reply to this Message

Rate this thread: