Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2014, 08:33 AM
CCCPWDES CCCPWDES is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 64bit
Novice
Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous"
 
Join Date: Mar 2014
Location: Martinez
Posts: 3
CCCPWDES is on a distinguished road
Angry Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous"

This is an issue I've fought since 1995!!!
I've yet to find training for "programming" macros, etc. in Word - although I admit I gave up years ago since I don't do many mail merges - but now we're starting to, SO, a BIG S.O.S.!



1. How do I get 2-page letters to have "2 of 2" (instead of "45 of 300," etc.) on the second page after a merge, as well as,

2. HOW (& what default setting do I change/how) do I get Word NOT to have "continuous numbering from previous" (for numbered lists) in every separate letter after the first.

Gosh knows Word is always trying to show me how much smarter it is than I am and this is one of those times when it just causes me Grief - SINCE 1995!!!

I shouldn't have to learn VBA to do a simple 2-page letter mail merge for 200 recipients.

grumble, growl.

I appreciate any assistance with this lifelong adventure.
Reply With Quote
  #2  
Old 03-06-2014, 08:55 AM
Charles Kenyon Charles Kenyon is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Use a SectionPages field instead of NumPages field.

Or, if the letter will always be two pages, use a different first-page header. Just use the number 2 for the second page's header rather than a field.

See Mail Merge.

Last edited by Charles Kenyon; 03-06-2014 at 08:58 AM. Reason: Add link.
Reply With Quote
  #3  
Old 03-10-2014, 11:11 AM
CCCPWDES CCCPWDES is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 64bit
Novice
Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous"
 
Join Date: Mar 2014
Location: Martinez
Posts: 3
CCCPWDES is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
Use a SectionPages field instead of NumPages field.

Or, if the letter will always be two pages, use a different first-page header. Just use the number 2 for the second page's header rather than a field.

See Mail Merge.
Thanks, I will try that code instead. The letters/docs can be between 2 pages and 50 - so much fun when things go awry. :-) Any ideas on the numbered lists in the letters/docs? How to kill that "continue from previous" code.
Thanks again, I really appreciate the help.
Reply With Quote
  #4  
Old 03-12-2014, 08:00 AM
Charles Kenyon Charles Kenyon is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Hadn't noticed that question. I would code the lists to restart numbering, even though it is the first instance. Do not know that this will work, but it is where I would start.
Reply With Quote
  #5  
Old 03-12-2014, 08:08 AM
Charles Kenyon Charles Kenyon is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Just double-checked and I do not have the numbering problem in my merges. I suspect it is because I use outline numbering tied to styles as set out in How to create numbered headings or outline numbering in Ribbon Versions of Word by Shauna Kelly rather than a simple numbered list.

Just tried a simple list as well and no problem, it restarted for each new record.
I just tried telling the list to restart and still no problem. What kind of numbering are you using? A SEQ field perhaps?
Reply With Quote
  #6  
Old 03-12-2014, 08:12 AM
Charles Kenyon Charles Kenyon is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Nope, tried to reproduce your problem using a SEQ field and I could not get that to do it either.
Reply With Quote
  #7  
Old 03-12-2014, 08:13 AM
Charles Kenyon Charles Kenyon is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Any chance you are using a document converted from Word Perfect or some other Word Processing program (a bad idea, by the way).
Reply With Quote
  #8  
Old 03-12-2014, 08:20 AM
Charles Kenyon Charles Kenyon is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by CCCPWDES View Post
... I've yet to find training for "programming" macros, etc. in Word ....
I started with this:
Macros and VBA (Visual Basic for Applications)

I then moved to
UserForms.

Here is a link to a book I have used:
Mastering VBA for Office 2010 by Richard Mansfield

However, nothing you mentioned so far should require vba.
Reply With Quote
  #9  
Old 03-12-2014, 03:39 PM
macropod's Avatar
macropod macropod is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 32bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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 X of Y page numbering can be handled by using a SECTIONPAGES field instead of the default NUMPAGES field.

The paragraph numbering can likewise be handled via SEQ fields, etc., as indicated by Charles.

None of this requires VBA and the solutions have been available since before 1995 ... they were already present in Office 4 (which I used and didn't even have VBA), released in 1993. They may even have been present in the DOS versions of Word, but I really don't remember.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 03-17-2014, 08:01 AM
CCCPWDES CCCPWDES is offline Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Windows 7 64bit Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Office 2010 64bit
Novice
Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous"
 
Join Date: Mar 2014
Location: Martinez
Posts: 3
CCCPWDES is on a distinguished road
Default Thanks for all the input

I'm generating a fresh new document - no legacying from WP, etc. the manual numbering on page two onward is probably the only way to go.
I'll try the "start numbering at" for the list - so far it only worked on the first merged document and subsequent letters defaulted to "continue number from previous." I'll see if a style will remedy that, but not sure how to really do that. We have to keep stuff dummied down because we have turnover at these desks every 1-4 years and most people here don't know macros or even setting tabs sometimes!
Thanks again for all the input - I will see if I can get it to work and will let y'all know.
Reply With Quote
Reply

Tags
mail merge, numbered lists, page numbering letters

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Problem with "Next page" section break automatically turning into "Odd or Even Page" c_gallagher25 Word 1 02-12-2014 04:27 PM
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon CensorTilSin Outlook 1 12-11-2013 12:05 PM
Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Applying "Paper Source" settings to multiple sections in a mail merge does not apply ChrisC Mail Merge 1 06-18-2012 07:11 PM
why the "section break-next page" is switched to "section break-continuous"? Jamal NUMAN Word 6 12-14-2011 03:35 PM
Since 1995: Mail Merge-Page Nos. & Numbered Lists "continuous" Continuous page numbers with mail merge? Jennifer Murphy Mail Merge 1 08-11-2011 05:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:43 AM.


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