Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2015, 08:08 PM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default Missing records after word mailmerge

Hi,

May I seek your assistance that I try the letter template Y79.doc, mailmerge manually with all 4 record from Y79.txt file, I can see all of them in the process, after mailmerge - edit individual record (all), I see only first 2 of the 4 are merged in the final document, seems the page layout have affect the final result, but I am unsure how to resolve, any suggestion will be appreciated?

I am using MS word 2007.

(There is no <next record> in the template).
Attached Files
File Type: doc Y79.doc (54.0 KB, 15 views)
File Type: txt Y79.txt (1.1 KB, 11 views)

Last edited by matthewchin; 11-04-2015 at 08:21 PM. Reason: re-upload files are needed
Reply With Quote
  #2  
Old 11-04-2015, 09:20 PM
macropod's Avatar
macropod macropod is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge 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

Using Word 2010, all four records are merged. I doubt that it would be any different for Word 2007. Are you doing a letter merge? Letter merges do not use a «NextRecord» field - if you have such a field, every second record will be skipped.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-04-2015, 10:04 PM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default

HI ,

I am doing letter merge, and there is no <next record> in it.
Reply With Quote
  #4  
Old 11-04-2015, 10:27 PM
macropod's Avatar
macropod macropod is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge 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

As I have already said, all four records are merged when I do it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-04-2015, 10:30 PM
macropod's Avatar
macropod macropod is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge 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

Cross-posted at: http://answers.microsoft.com/en-us/o...a-0b7890f60802
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 11-04-2015, 10:40 PM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default

Thanks for the tips.

I will take note on this, because I am unsure these are related forums.

Thanks
Reply With Quote
  #7  
Old 11-04-2015, 10:43 PM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default

Thx Paul,

But the shop here is using MS word 2007, can I know if there is any more hint to get the issue resolved.
Reply With Quote
  #8  
Old 11-05-2015, 04:04 PM
macropod's Avatar
macropod macropod is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge 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 could try opening the text file in Excel, then use the text-to-columns feature to split the data at the ~ characters. Once you've done that, you can use the Excel file as your data source. If you use the same Excel file each time, your mailmerge also won't need to be re-connected to the data source each time.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 11-05-2015, 11:10 PM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default

That involve plenty re-work, which is not a feasible / preferable solution.
1) When .TXT file open in excel, numeric fields need special handling in oder not to confuse the original data contents.
2) this shop have over hundred letters, opened using .TXT data source now.
Reply With Quote
  #10  
Old 11-05-2015, 11:26 PM
macropod's Avatar
macropod macropod is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge 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

As I have said in previous posts, I don't have any trouble merging all your records. Have you tried repairing the Office installation (via Start > Windows Control Panel > Programs > Programs & Features > Microsoft Office (version) > Change>Repair)?

As for importing the data into Excel, I don't see why you believe that will create any issues with numeric data. You might also get better results if your data were generated in a standard format, with commas or tabs as field delimiters instead of tildes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 11-06-2015, 12:41 AM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default

Hi Paul,
Thx for advice.
1) we do not have manual intervention in the process when data file .TXT import to mailmerge in word now, as say, we have over hundred letters, so not prefer change in this process.
2) numeric field H96 under type 'general' will have data 1234567890123456 change to 1234567890123450 after save in excel, that is not wanted, unless handle manually.
3) Is there is a fix in the word 2007 ? As we have other letter ok in import/merge more than 1 record. Change>Repair will be tested later as this need administrator.
Reply With Quote
  #12  
Old 11-06-2015, 04:54 AM
macropod's Avatar
macropod macropod is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge 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

1. The process could also be automated, so that you don't have to do the conversions manually. In any event, if you changed the separators from tildes to the more standard commas or tabs, the problem might go away of its own accord.

2. When you use Excel's text to columns tool, you can specify the format for each column. You can prevent 1234567890123456 changing to 1234567890123450 by specifying the 'text' format for that column.

3. If this problem has only recently started happening, something has changed in your working environment - either Office has developed a fault or some other aspect of your system has been changed (e.g. you've started using tildes instead of commas or tabs for the separators).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 11-10-2015, 12:15 AM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default

Hi Paul,

I understand we can automated the process.
At the time being, we have over hundred different .txt files input which is automated to feed to word (>100 different letter templates) for the mailmerge.

If we need to change to excel, and that need non-unified process to change this auto process, as each .TXT can have variable numeric fields that need 'text' type to be changed by excel, so why I told it is not a preferable process, as letter-1 may need column a,c with 'text' type, letter-2 may need column d,e with 'text' type, letter-2 may need column a,d with 'text' type etc.

Nothing have changed we using '~' so far in all these .TXT files, and they work, except this Y79.doc.

I tried remove also '~' at the end of each record for process, but it did not work.

I hope I have described our situation clearly and why I want a MS word itself solution.
Reply With Quote
  #14  
Old 11-10-2015, 01:21 AM
macropod's Avatar
macropod macropod is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge 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

As I said in my previous reply:
Quote:
3. If this problem has only recently started happening, something has changed in your working environment - either Office has developed a fault or some other aspect of your system has been changed (e.g. you've started using tildes instead of commas or tabs for the separators).
Until you address that - and repair Office to rule out problems on that front - progress is unlikely.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #15  
Old 11-10-2015, 03:22 AM
matthewchin matthewchin is offline Missing records after word mailmerge Windows 7 64bit Missing records after word mailmerge Office 2003
Novice
Missing records after word mailmerge
 
Join Date: Nov 2015
Posts: 11
matthewchin is on a distinguished road
Default

Thanks Paul.

Office 2007 is repaired once successfully, and I have retry with the same issue.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Selectively Merge Records to Different Places in a Word Directory-type Document TotheMoonAlice Mail Merge 3 03-27-2015 08:11 AM
Missing records after word mailmerge How to combine several records in a single letter in Word 2010 May Mail Merge 3 03-25-2015 03:36 AM
Missing records after word mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 8 02-11-2013 04:40 AM
Missing records after word mailmerge Mailmerge to Email with a mailmerge attachment Baldeagle Mail Merge 13 05-29-2012 02:04 PM
Missing records after word mailmerge Access to Word, Creating a list from multiple records daymaker Mail Merge 9 03-14-2012 06:37 AM

Other Forums: Access Forums

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