Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table in a Form | Tables | |||
Macro Button Won't Stay on Toolbar | Microsoft Word Help | |||
Possible bug when recording a Word Macro | Microsoft Word Help | |||
Save As is not working due to macro security settings | Microsoft Word Help | |||
2000 to 2002 macro and "Could not open macro storage" | Mailmerge |