Significant Blank Space At Top Of Page When Records Merged 1 Per Page

macropod · #16 05-03-2017, 04:58 PM

Quote:

Originally Posted by JennEx

Quote:

Originally Posted by macropod

... is that your macro seems to be running the merge from a different workbook than the one containing the data source.

Correct ... my 'application' workbook holds the code. It relies on a workbook serving as a database as each date has it's own. The application can call on any date to pull reports from.

Quote:

Originally Posted by macropod

Furthermore, it closes the mailmerge source workbook if it's open.

I did not know that. When I go to my application worksheet, I can access the data workbook ... but ... it's hidden. If I unhide it, I have access to it as it is open. (?) Could the fact the data workbook is hidden play a role?

The code that ensures the source workbook is closed before the merge runs is:

Code:

    'close data file
    st_srchfn = "u:\PWS\Parks\Parks Operations\Sports\Sports17\DATA\" & ws_vh.Range("N2")
    If wb_nwb Is Nothing Then
        MsgBox wb_nwb & " is NOT open."
    Else
        wb_nwb.Close True 'saves data workbook after TYPE was updated for GS
    End If

Since the workbook gets closed, it doesn't matter whether it was hidden beforehand. I doubt it would matter anyway.

Quote:

Originally Posted by JennEx

I would call that success. But, the 'Page of Pages' still refuses to populate. This is what I find to be most mysterious. If you refer to the document created by the macro launched merge in post 9 (https://drive.google.com/file/d/0B9E...ew?usp=sharing) with the file you provided, these merge fields populate although I have more than one record per page.

But with the code changes I suggested in my last post (post #14), you should now be getting one page per record. And, hopefully, the correct 'Page of Pages' output; if not, what is the incorrect 'Page of Pages' output you're getting?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Blank space at top of page	Vecchia	Word	4	12-26-2014 07:44 AM
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
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