Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2013, 06:55 AM
MaxBuck MaxBuck is offline Mail Merge Auto Numbering Windows 7 64bit Mail Merge Auto Numbering Office 2007
Novice
Mail Merge Auto Numbering
 
Join Date: Feb 2013
Posts: 6
MaxBuck is on a distinguished road
Default Mail Merge Auto Numbering

OK, what if I have no choice in a mail-merge but to use auto-numbering?



I use a report template in which I use mail-merge to input certain data that are different from project to project. After using mail-merge with my template doc, I cannot edit the section heading numbers; they all default to 1.0 (and obviously the subsections default to 1.1, 1.2, etc.). I can't change the numbers in the merged document to the proper section number, even by trying to force section 2 numbering to 2.0; Word forces the number back to 1. This problem just cropped up! (I have edited the template and associated input database to incorporate some new data entries, and after I did so is when the problem arose.)

Any ideas?
Reply With Quote
  #2  
Old 02-19-2013, 05:33 PM
macropod's Avatar
macropod macropod is offline Mail Merge Auto Numbering Windows 7 64bit Mail Merge Auto Numbering 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

In a mailmerge, one would ordinarily want the 'section heading numbers' to re-start at 1 for each recipient. It would look rather odd to have the same content for each recipient numbered differently, with their first heading, for example, reflecting not its position in their letter but their position in the mailmerge sequence.

Given the above, why do you need the 'section heading numbers' to increment and what kind on mailmerge are you performing (eg letter, directory/catalog)?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-19-2013, 06:32 PM
MaxBuck MaxBuck is offline Mail Merge Auto Numbering Windows 7 64bit Mail Merge Auto Numbering Office 2007
Novice
Mail Merge Auto Numbering
 
Join Date: Feb 2013
Posts: 6
MaxBuck is on a distinguished road
Default

I'm using mail merge only to fill data fields within a report, and only one "record" is being used (in other words, it's a single-recipient mail merge with many mergefields). The problem is that the section numbering appears to be fouled up during the mail merge process.

I've fixed the problem, however, using the "List Styles" feature for section numbering. I had to switch some headers (toggle between, say, Heading 3 and Heading 4) to get the numbers to update properly, but that's a minor problem.
Reply With Quote
  #4  
Old 02-19-2013, 07:03 PM
macropod's Avatar
macropod macropod is offline Mail Merge Auto Numbering Windows 7 64bit Mail Merge Auto Numbering 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 MaxBuck View Post
I'm using mail merge only to fill data fields within a report, and only one "record" is being used (in other words, it's a single-recipient mail merge with many mergefields). The problem is that the section numbering appears to be fouled up during the mail merge process.
In that case, mailmerge is unlikely to have been the cause of your problem.

That said, mailmerge might not be the best tool for this situation - employing a userform that retrieves the data from the appropriate record, then either updates the document directly or updates a set of document properties that are linked to DOCPROPERTY fields in the document might be a better approach.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-19-2013, 07:55 PM
MaxBuck MaxBuck is offline Mail Merge Auto Numbering Windows 7 64bit Mail Merge Auto Numbering Office 2007
Novice
Mail Merge Auto Numbering
 
Join Date: Feb 2013
Posts: 6
MaxBuck is on a distinguished road
Default

Given that I already have the mailmerge document as a template, it's unlikely I'll change horses at this point. But for a new report, if I need one, I'll look into this approach. Thanks for the feedback!
Reply With Quote
  #6  
Old 02-19-2013, 08:13 PM
macropod's Avatar
macropod macropod is offline Mail Merge Auto Numbering Windows 7 64bit Mail Merge Auto Numbering 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

Just to tweak your interest: http://www.fontstuff.com/mailbag/qword02.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Auto Numbering Can mail merge be used to auto attach docs to outlook gm2034500 Mail Merge 1 12-26-2012 03:44 PM
Mail Merge Auto Numbering auto page numbering socomfort Word 2 05-28-2012 04:19 PM
Mail Merge Auto Numbering Auto-numbering non co-located Requirements in a document acheo Word 1 11-24-2011 05:24 PM
URGENT: Mail 'Merge To New Doc' restarts paragraph numbering at each Section break JamesF Mail Merge 0 07-28-2011 07:26 AM
Mail Merge Auto Numbering Correct figure auto-numbering JFax Word 1 05-08-2011 09:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:51 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