Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #17  
Old 05-04-2017, 06:58 AM
JennEx JennEx is offline Significant Blank Space At Top Of Page When Records Merged 1 Per Page Windows XP Significant Blank Space At Top Of Page When Records Merged 1 Per Page Office 2013
Competent Performer
Significant Blank Space At Top Of Page When Records Merged 1 Per Page
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Yes ... one report per page which is the important thing. However, I have noticed though that my other mail merge documents that rely on this code have been affected. The DT15v1.docx mail merge document that you have become far too familiar with is the only one in which one record per page is needed. My other similar reports that rely on the macro now have just one report per page (when they could have up to 3).

I think this can be fixed relatively easy in my macro by changing this line line (maybe)

Code:
If Left(itype, 1) <> "G" Then   'exclude GS reports
to
Code:
If Left(itype, 1) <> "G" and itype <> "DT" Then   'exclude GS and DT reports
The 'Page of Pages' thing I can sacrifice for everything else working. I think the mystery remains. It is so unpredictable. I printed off a couple reports just now to share, but they were both fine. Last night, not so much. Weird. The only difference between the two sessions of report printing from my application was from where. One was done from home and failed, the other at school which succeeded. Both Word versions are 14, but one is from Home Suite the other Professional respectively.

Paul, you have been an incredible help. As frustrating as it was at times, I appreciate your patience and your generosity. You offered a balance of provision and guidance for self support which was a great learning opportunity. All I can offer in return is sincerest appreciation.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Significant Blank Space At Top Of Page When Records Merged 1 Per Page Blank space at top of page Vecchia Word 4 12-26-2014 07:44 AM
Significant Blank Space At Top Of Page When Records Merged 1 Per Page Removing space before blank page / page break greasel Word 5 10-17-2014 07:04 PM
Insert page break vs blank page harvey4 Word 2 08-20-2014 07:15 PM
Multiple records on the same page Hugh Mail Merge 2 04-04-2014 05:24 PM
Significant Blank Space At Top Of Page When Records Merged 1 Per Page First section will not 'insert' blank page even though sectn 2 is 'odd' page break Pat_Hodgson Word 6 12-01-2013 04:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft