Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #46  
Old 04-08-2016, 05:53 AM
macropod's Avatar
macropod macropod is offline Applications Hanging During Merge Windows 7 64bit Applications Hanging During Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #47  
Old 04-08-2016, 06:30 AM
JennEx JennEx is offline Applications Hanging During Merge Windows XP Applications Hanging During Merge Office 2013
Competent Performer
Applications Hanging During Merge
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

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.
Reply With Quote
  #48  
Old 04-08-2016, 07:14 AM
JennEx JennEx is offline Applications Hanging During Merge Windows XP Applications Hanging During Merge Office 2013
Competent Performer
Applications Hanging During Merge
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

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.
Reply With Quote
  #49  
Old 04-08-2016, 07:21 AM
macropod's Avatar
macropod macropod is offline Applications Hanging During Merge Windows 7 64bit Applications Hanging During Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #50  
Old 04-08-2016, 07:23 AM
macropod's Avatar
macropod macropod is offline Applications Hanging During Merge Windows 7 64bit Applications Hanging During Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by JennEx View Post
The merge document is several pages showing the mergefields and their formula and switches etc. If I choose to preview results, nothing changes.
You have Word's field code display toggled on. Pressing Alt-F9 toggles on/off.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #51  
Old 04-08-2016, 07:56 AM
JennEx JennEx is offline Applications Hanging During Merge Windows XP Applications Hanging During Merge Office 2013
Competent Performer
Applications Hanging During Merge
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You have Word's field code display toggled on. Pressing Alt-F9 toggles on/off.
Duh. I totally overlooked that.
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
Reply With Quote
  #52  
Old 04-08-2016, 04:55 PM
macropod's Avatar
macropod macropod is offline Applications Hanging During Merge Windows 7 64bit Applications Hanging During Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by JennEx View Post
Duh. Do you think I'll be OK on my own trying the remaining 5 reports??
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]
Reply With Quote
  #53  
Old 04-10-2016, 06:55 PM
JennEx JennEx is offline Applications Hanging During Merge Windows XP Applications Hanging During Merge Office 2013
Competent Performer
Applications Hanging During Merge
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default 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!
Reply With Quote
  #54  
Old 04-10-2016, 07:23 PM
macropod's Avatar
macropod macropod is offline Applications Hanging During Merge Windows 7 64bit Applications Hanging During Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing data between Office applications mdavies Office 1 11-26-2013 02:55 PM
Applications Hanging During Merge All Office Applications lock up when saving abreeden Office 1 05-18-2012 08:02 PM
Applications Hanging During Merge 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:40 PM.


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