A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

mail merge batch file



 
 
Thread Tools Display Modes
  #1  
Old April 29th, 2005, 06:48 PM
Josh
external usenet poster
 
Posts: n/a
Default mail merge batch file

I am trying to set up a batch file to run a mail merge each day. I will but
it in windows scheduler, however I am having trouble getting the letters to
auto print.

Can I save the mail merge .dot to automatically print the letters when you
execute the file? Or is there a way in a batch file upon opening the .dot
file to tell it to print to merge and then close Word?

Anyone done this before? Help would be greatly appreciated.
  #2  
Old April 29th, 2005, 07:08 PM
Simon Ayling
external usenet poster
 
Posts: n/a
Default

A /really/ simple way of doing this would be to record (not write) a macro
while you did all the bits you want, then save that macro to your normal
template (i.e. store the macro in 'All documents', an option available
before you start recording.

You can then schedule word to open and run that macro whenever you wish to
have it scheduled to run for...

"Josh" wrote in message
...
I am trying to set up a batch file to run a mail merge each day. I will
but
it in windows scheduler, however I am having trouble getting the letters
to
auto print.

Can I save the mail merge .dot to automatically print the letters when you
execute the file? Or is there a way in a batch file upon opening the .dot
file to tell it to print to merge and then close Word?

Anyone done this before? Help would be greatly appreciated.



  #3  
Old April 29th, 2005, 08:00 PM
Josh
external usenet poster
 
Posts: n/a
Default

Thanks for the idea. I'll give it a try and see how it works.

"Simon Ayling" wrote:

A /really/ simple way of doing this would be to record (not write) a macro
while you did all the bits you want, then save that macro to your normal
template (i.e. store the macro in 'All documents', an option available
before you start recording.

You can then schedule word to open and run that macro whenever you wish to
have it scheduled to run for...

"Josh" wrote in message
...
I am trying to set up a batch file to run a mail merge each day. I will
but
it in windows scheduler, however I am having trouble getting the letters
to
auto print.

Can I save the mail merge .dot to automatically print the letters when you
execute the file? Or is there a way in a batch file upon opening the .dot
file to tell it to print to merge and then close Word?

Anyone done this before? Help would be greatly appreciated.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can't I see ALL columns in Excel file during mail merge? Halley Mailmerge 3 April 29th, 2005 01:55 PM
Mail merge contact data file mel Contacts 0 February 11th, 2005 02:03 PM
mail merge with attachments AS Mailmerge 3 December 21st, 2004 04:11 AM
Print mail merge file to send to quick print shop Gordon Jones Publisher 18 November 14th, 2004 11:13 PM
mail merge - how to insert a word file in main document as a filed Manikrishna Mailmerge 1 May 7th, 2004 10:13 AM


All times are GMT +1. The time now is 05:19 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.