#46
|
||||
|
||||
Jenn,
What you need to understand is that a Directory merge cannot have a different header/footer on every page (unless you use the 'different first page' and 'different odd & even' page layouts and limit the merge to 3 pages), let alone for every record. If you compare the output from a Directory merge and a Letter merge with either my last attachment or your latest, you'll see exactly that difference.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#47
|
|||
|
|||
No worries, I am having (or had) success integrating your code for post 30 into my project. My first attempt the records didn't have any space between them, so I tried to add a blank line after the main table in the merge document. It may or may not have worked as the page number thing is taking up more room than it would (since it's not populating) if it was working. That bit of extra space may be the difference of whether the second record fits below the first or not.
The code you provided to address the page numbering thing you mentioned not to use if I use the code in post 30. That being said, with the page numbering still not functional, is there a work aroound? I could live without, but as I said in one of my earlier post, I can't find three of the cells of the footer table in the merge document when all the fields are showing. |
#48
|
|||
|
|||
One other frustration I seem to be having with this report, is when I open the report manually to edit for instance, I select the recipients using an existing list, edit the recipients for DR and HPL for example (I know that there is E2 data available there).
The merge document is several pages showing the mergefields and their formula and switches etc. If I choose to preview results, nothing changes. When normally I could scroll through the records to see the data populating the report, all I see now is the merge field text. The only way I can see the data, is to select each merge field in the report and 'toggle field code'. But as soon as I select to scroll to the next record, I have to repeat that. What am I doing wrong? This makes editing of the report very difficult, as the only way I can see the entire body, header and footer table as one to make any changes is the minimize everything by manually toggling the fields to bring everything together. Otherwise, its all broken up in its merge field view among several pages. |
#49
|
||||
|
||||
The code from post #30 is really just another way of getting much the same result as you'd get from a Directory merge - the same header & footer throughout the document. The only difference is that there's a paragraph break between the record tables. Conversely, with two paragraph breaks after the table instead of one in the mailmerge main document, a Directory merge's output would be the same.
The alternate code in post #44, when used with a Letter merge, lets you have a separate header & footer for each record but with continuous page numbering.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#50
|
||||
|
||||
You have Word's field code display toggled on. Pressing Alt-F9 toggles on/off.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#51
|
|||
|
|||
Quote:
It would appear as though I have things working OK now, but I fear jinxing myself. I'm getting multi records on one page with the page number populating corrrectly. Do you think I'll be OK on my own trying the remaining 5 reports?? Last edited by JennEx; 04-08-2016 at 08:31 AM. Reason: Added file |
#52
|
||||
|
||||
You can but try. Now that you've got one good one, you might use that as a base for any others that are substantially the same so as to minimise the amount of field work that might be required..
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#53
|
|||
|
|||
Still Problems With Merging Times
Hi Paul,
I just wanted to extend my sincere thanks for all your effort and kind contributions in helping me work through the problems I experienced in this thread. Your unselfish and generous help was greatly appreciated, and I feel words are too little of a thank you. I am confident that I have my reports working as hoped. Thank you very much Paul! |
#54
|
||||
|
||||
You're welcome. I'm always happy to help those who are prepared to make an effort rather than wanting someone else to do the work for them.
Combining mailmerges with VBA code, Word automation, SQL statements, different mailmerge main documents and datasources, with the complication that the latter, for whatever reason, don't correctly return time values, are not things the average user would soon master.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sharing data between Office applications | mdavies | Office | 1 | 11-26-2013 02:55 PM |
All Office Applications lock up when saving | abreeden | Office | 1 | 05-18-2012 08:02 PM |
VB Applications? | RiverStyx | Office | 1 | 05-30-2011 08:31 PM |
Change skin color of applications? | Jack R | Office | 0 | 07-04-2010 04:25 AM |
How many Word applications are running GetObject | stevecarr | Word | 0 | 01-09-2006 07:41 AM |