Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Batch file for Macro

Status
Not open for further replies.
AJD10

AJD10

MIS
Apr 26, 2002
46
US
How do I execute a Word macro (to perform a mail merge process) from a batch file?

Also, is there a specific way to save the macro? (i.e., "All active templates and documents")

Thanks in advance!
 
Sort by date Sort by votes
Hi,

The Batch file would have to open a Word document, 'cuz a VBA Word macro can ONLY run in Word. Then the Word document could fire your merge macro in the Document_Open event.

So why not just open the Word document and let 'er rip! ???

Save your Merge macro in the Word document.

:)

Skip,
Skip@TheOfficeExperts.com
 
Upvote 0 Downvote
Great idea! Thanks.

The only reason we need to do this via batch process is because data files will be recieved from one place, renamed, merged and moved to another place (on a daily basis now!)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

techguy2010
  • Locked
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
763
techguy2010
techguy2010
Andrzejek
  • Locked
  • Question
Word - Mail merge file names 1
Replies
2
Views
1K
Andrzejek
Andrzejek
E
  • Locked
  • Question
Copying spreadsheet for posting
Replies
2
Views
477
combo
combo
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
613
SkipVought
S
kwbMitel
  • Locked
  • Question
Lost edited data in Excel File
Replies
3
Views
354
Scott24x7
Scott24x7

Part and Inventory Search

Sponsor

Back
Top