(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Background printing with WordMerge
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Background printing with WordMerge (Read 786 times)
carsten
Junior Member
**
Offline


Carpe Diem

Posts: 74
Location: Germany
Joined: Aug 24th, 2005
Background printing with WordMerge
Jul 28th, 2006 at 1:27pm
Print Post Print Post  
How do I print in the background with WordMerg? I allways have the application open Word and need to do the print mannually.

Thanks
Carsten
  
Carsten&&The Houseman&&"Smiling improves your face value"&&"A Clean House is a Sign of a Wasted Life"&&"Rather Big and Hard then Micro and Soft"
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Background printing with WordMerge
Reply #1 - Jul 28th, 2006 at 1:45pm
Print Post Print Post  
carsten wrote on Jul 28th, 2006 at 1:27pm:
How do I print in the background with WordMerg? I allways have the application open Word and need to do the print mannually.


By embedding a bit of VBA in the Word document. This snippet automatically prints the merged document and closes Word.

Code
Select All
Private Sub Document_Open()

    ActiveDocument.MailMerge.Destination = wdSendToPrinter
    ActiveDocument.MailMerge.Execute
    Application.Quit wdDoNotSaveChanges

End Sub

  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
carsten
Junior Member
**
Offline


Carpe Diem

Posts: 74
Location: Germany
Joined: Aug 24th, 2005
Re: Background printing with WordMerge
Reply #2 - Jul 28th, 2006 at 2:46pm
Print Post Print Post  
Marvelous!!!

This forum and especially the commitment of the Lanticans is absolutely fabulous!!!

Thanks a lot again, I had been trying to figure this out for 5 hours myself!

-Carsten
  
Carsten&&The Houseman&&"Smiling improves your face value"&&"A Clean House is a Sign of a Wasted Life"&&"Rather Big and Hard then Micro and Soft"
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Background printing with WordMerge
Reply #3 - Jul 28th, 2006 at 3:20pm
Print Post Print Post  
For what it's worth, there's lots of information about making Word do things here:
http://word.mvps.org/FAQs/MailMerge/index.htm
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge