Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
IGISpokane IGISpokane is offline
external usenet poster
 
Posts: 1
Default Mailmerge and Excel

I have a minolta 75 ppm machine with a folding finisher on it. I have
created a word document and an excel spreadsheet to do a mail merge mailing.
I want to do a half fold on legal paper. The machine will accomplish this
task when printed without the mail merge component. As soon as I introduce
the mail merge the folding feature does not work. If I reprint the orginal
document without the mail merge everything comes out as I need.

Both applications are 2002 version.

Any and all suggestions and ideas are welcome

Thanks

Mike

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mailmerge and Excel

You will probably need to execute the mailmerge to a new document and then
use a macro to send each letter to the printer as a separate print job. The
following is the code that you will need to do that

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count Step 1
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With


--
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

"IGISpokane" wrote in message
...
I have a minolta 75 ppm machine with a folding finisher on it. I have
created a word document and an excel spreadsheet to do a mail merge
mailing.
I want to do a half fold on legal paper. The machine will accomplish this
task when printed without the mail merge component. As soon as I
introduce
the mail merge the folding feature does not work. If I reprint the
orginal
document without the mail merge everything comes out as I need.

Both applications are 2002 version.

Any and all suggestions and ideas are welcome

Thanks

Mike



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
How do I print an Excel Autoshape on a Word doc using mailmerge? TG in AZ Mailmerge 2 February 25th 06 04:15 PM
mailmerge using Word/Excel 500.00 in Excel shows as 500 nt 500.00 Switchengine Mailmerge 1 January 29th 06 07:53 PM
Excel as mailmerge data source Mary Ann Mailmerge 2 December 6th 05 06:10 PM
excel hangs in mailmerge harrow Microsoft Word Help 2 October 21st 05 04:48 AM
Mailmerge from EXCEL, custom format problem TonyB Mailmerge 1 December 1st 04 04:41 PM


All times are GMT +1. The time now is 08:43 PM.

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"