Microsoft Office Forums Mail Merge Problem

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2012, 01:23 PM
Hook Hook is offline Mail Merge Problem Mac OS X Mail Merge Problem Office for Mac 2011
Novice
Mail Merge Problem
 
Join Date: Jan 2012
Posts: 4
Hook is on a distinguished road
Default Mail Merge Problem

I just merged two different letters and two different data sources to two separate files. Each letter contains a the same numbered list

The letters read as follows (no merge fields in any of the text in the three numbered lines neither are the numbers.)

text
1. text
2. text
3. text
text

When I reviewed the resulting letters in each file prior to saving it, they read:

Letter number 1:
text
1 text


2. text
3. text
text
To the last one--
Document number 106:
text
1. text
2. text
3. text
text

When I saved the files and reopen them, both read:

Letter number 1:
text
1. text
2. text
3. text
text
To the last one--
Document number 106:
text
316. text
317. text
318. text
text

Each list in all 106 in both has been incremented. The act of saving the files seems to have caused the problem.

Have no idea why.

I have been able to duplicate the results several times, so I don't think I'm dreaming.


Anyone have a clue?

Thanks,

Hook
Reply With Quote
  #2  
Old 01-10-2012, 06:18 PM
macropod's Avatar
macropod macropod is offline Mail Merge Problem Windows 7 64bit Mail Merge Problem Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

hi Hook,

The problem is that your mailmerge main document has auto-numbered paragraphs. The numbering sequence carries through into the output document and anything that causes Word to refresh the numbering (eg printing, previewing, closing & re-opening) will result in the effect you're seeing. The simplest solution is to abandon the auto-numbering.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 01-11-2012, 09:36 AM
Hook Hook is offline Mail Merge Problem Mac OS X Mail Merge Problem Office for Mac 2011
Novice
Mail Merge Problem
 
Join Date: Jan 2012
Posts: 4
Hook is on a distinguished road
Default

Thanks very much, Paul.

The original wasn't mine but I suspected that might be the problem.

But when I looked at the merged documents the second time I ran them and they looked ok , I thought I'd made the wrong decision.

I appreciate your helping me out of a jam with my boss, since she wrote the
letter.


Hook
Reply With Quote
  #4  
Old 01-11-2012, 09:50 AM
Hook Hook is offline Mail Merge Problem Mac OS X Mail Merge Problem Office for Mac 2011
Novice
Mail Merge Problem
 
Join Date: Jan 2012
Posts: 4
Hook is on a distinguished road
Default

Now if you'd be kind enough to remind me how to mark this as "solved" I'll do just that.

Hook
Reply With Quote
  #5  
Old 01-11-2012, 09:52 AM
macropod's Avatar
macropod macropod is offline Mail Merge Problem Windows 7 64bit Mail Merge Problem Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi Hook,

It's under 'Thread Tools'.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #6  
Old 01-11-2012, 10:05 AM
Hook Hook is offline Mail Merge Problem Mac OS X Mail Merge Problem Office for Mac 2011
Novice
Mail Merge Problem
 
Join Date: Jan 2012
Posts: 4
Hook is on a distinguished road
Default

Done and done.

H.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge problem when converting to PDF roflzor Mail Merge 7 09-30-2013 06:50 AM
Mail Merge Problem Mail Merge for Labels Problem Debz831 Mail Merge 5 10-31-2011 01:48 AM
Printing problem with mail merge irenej48 Mail Merge 0 01-01-2010 03:03 PM
Mail Merge Problem JohnRG Mail Merge 0 11-02-2009 02:50 AM
problem in Mail merge rjagathe Mail Merge 0 08-12-2009 08:25 AM


All times are GMT -7. The time now is 05:30 AM.


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