#16
|
||||
|
||||
Quote:
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 Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#17
|
|||
|
|||
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 Code:
If Left(itype, 1) <> "G" and itype <> "DT" Then 'exclude GS and DT reports 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. |
#18
|
||||
|
||||
Quote:
If (itype <> "GS") And (itype <> "DT") Then 'exclude GS and DT reports Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#19
|
|||
|
|||
Yep. That worked.
I will see what I can do to sort things out with my home installation hoping that will be the painless way of resolving this last annoyance. Thanks Paul. |
|
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 |