Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge - not showing all data
Back in 2006 Mech73 wrote the following:
Trying to do a labels mail merge in 'new' MS Word '03, using XL as my data source, but it's only recognising the first 16 items and totally ignoring the next 18...and this is only a trial run for 550! (That is, only showing 16 items in the "Edit recipients list".) Doug Robbins provided the following website to help: See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm I'm having a similar problem but in Word 2007. I went to the above article and used the solution suggested there. It worked for the first data source that I tried (showed all 4 records instead of 1) but when I tried the data source with 8 records it only showed me 4 records. The unique identifier of the data source is a number formatted as text so it reads as '123.4 instead of 123.4 but this used to work fine in the past it has just started playing up within the last week. The data source is an Excel file in compatibility mode so it has a .xls extension. All the merge field names are spelt the same in all data sources. It is just the data that changes. Is there anyone who can help me? -- Joyce |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge - not showing all data
I am not sure what the unique number of the data source has to do with
things, but are you actually executing the merge? How many labels are there on the sheet? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Joyce" wrote in message ... Back in 2006 Mech73 wrote the following: Trying to do a labels mail merge in 'new' MS Word '03, using XL as my data source, but it's only recognising the first 16 items and totally ignoring the next 18...and this is only a trial run for 550! (That is, only showing 16 items in the "Edit recipients list".) Doug Robbins provided the following website to help: See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm I'm having a similar problem but in Word 2007. I went to the above article and used the solution suggested there. It worked for the first data source that I tried (showed all 4 records instead of 1) but when I tried the data source with 8 records it only showed me 4 records. The unique identifier of the data source is a number formatted as text so it reads as '123.4 instead of 123.4 but this used to work fine in the past it has just started playing up within the last week. The data source is an Excel file in compatibility mode so it has a .xls extension. All the merge field names are spelt the same in all data sources. It is just the data that changes. Is there anyone who can help me? -- Joyce |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge - not showing all data
Hi Doug,
It's actually a form letter and we haven't executed it as when we look at the recipients under "Edit recipients list" there are some missing. The weird thing is, if we copy the data to a new spreadsheet and then attempt the mail merge, we get all the records showing under "Edit recipients list" without any problems. It is a weird problem. -- Joyce "Doug Robbins - Word MVP" wrote: I am not sure what the unique number of the data source has to do with things, but are you actually executing the merge? How many labels are there on the sheet? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Joyce" wrote in message ... Back in 2006 Mech73 wrote the following: Trying to do a labels mail merge in 'new' MS Word '03, using XL as my data source, but it's only recognising the first 16 items and totally ignoring the next 18...and this is only a trial run for 550! (That is, only showing 16 items in the "Edit recipients list".) Doug Robbins provided the following website to help: See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm I'm having a similar problem but in Word 2007. I went to the above article and used the solution suggested there. It worked for the first data source that I tried (showed all 4 records instead of 1) but when I tried the data source with 8 records it only showed me 4 records. The unique identifier of the data source is a number formatted as text so it reads as '123.4 instead of 123.4 but this used to work fine in the past it has just started playing up within the last week. The data source is an Excel file in compatibility mode so it has a .xls extension. All the merge field names are spelt the same in all data sources. It is just the data that changes. Is there anyone who can help me? -- Joyce |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
c# mail merge only showing date fields in merge | Mailmerge | |||
mail merge - not showing all data | Mailmerge | |||
Mail merge data not showing on Mail Recipient List | Mailmerge | |||
Merge fields not showing data in word footer | Mailmerge | |||
Mail Merge Data Not Showing for MS query | Mailmerge |