#1
|
|||
|
|||
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). Last edited by matthewchin; 11-04-2015 at 08:21 PM. Reason: re-upload files are needed |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
HI ,
I am doing letter merge, and there is no <next record> in it. |
#4
|
||||
|
||||
As I have already said, all four records are merged when I do it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
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] |
#6
|
|||
|
|||
Thanks for the tips.
I will take note on this, because I am unsure these are related forums. Thanks |
#7
|
|||
|
|||
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. |
#8
|
||||
|
||||
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] |
#9
|
|||
|
|||
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. |
#10
|
||||
|
||||
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] |
#11
|
|||
|
|||
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. |
#12
|
||||
|
||||
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] |
#13
|
|||
|
|||
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. |
#14
|
||||
|
||||
As I said in my previous reply:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#15
|
|||
|
|||
Thanks Paul.
Office 2007 is repaired once successfully, and I have retry with the same issue. |
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 |
How to combine several records in a single letter in Word 2010 | May | Mail Merge | 3 | 03-25-2015 03:36 AM |
Mailmerge to Email with a mailmerge attachment | Baldeagle | Mail Merge | 8 | 02-11-2013 04:40 AM |
Mailmerge to Email with a mailmerge attachment | Baldeagle | Mail Merge | 13 | 05-29-2012 02:04 PM |
Access to Word, Creating a list from multiple records | daymaker | Mail Merge | 9 | 03-14-2012 06:37 AM |