Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Matt
 
Posts: n/a
Default Macro will not run

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

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Macro will not run

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" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Matt
 
Posts: n/a
Default Macro will not run

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

"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
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
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
Table in a Form HiDbLevel Tables 12 February 27th 06 01:59 PM
Macro Button Won't Stay on Toolbar caleb Microsoft Word Help 2 June 14th 05 11:59 PM
Possible bug when recording a Word Macro Raven95 Microsoft Word Help 4 April 30th 05 09:49 PM
Save As is not working due to macro security settings Craig Meritz Microsoft Word Help 1 December 16th 04 04:53 AM
2000 to 2002 macro and "Could not open macro storage" Art Farrell Mailmerge 1 December 6th 04 01:40 PM


All times are GMT +1. The time now is 06:30 AM.

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

About Us

"It's about Microsoft Word"