If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
First Record's Letter Missing after Letter Merge
I am using Word 2002.
After I merge a letter from either Excel or Access, my first record is missing from the merged document, i.e., if I tell it to merge records 1 through 10, the merged document contains letters for records 2 through 10. This occurs whether I use the edit mail merge recipients list, and only check records 1 thru 10, or whether I select "merge to new document" on the toolbar and tell it to merge from 1 to 10. BTW, there are no NEXT or NEXT RECORD fields in the main document. Why is this?? |
#2
|
|||
|
|||
Does your data file use the first record as a header?
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org TS in FL wrote: I am using Word 2002. After I merge a letter from either Excel or Access, my first record is missing from the merged document, i.e., if I tell it to merge records 1 through 10, the merged document contains letters for records 2 through 10. This occurs whether I use the edit mail merge recipients list, and only check records 1 thru 10, or whether I select "merge to new document" on the toolbar and tell it to merge from 1 to 10. BTW, there are no NEXT or NEXT RECORD fields in the main document. Why is this?? |
#3
|
|||
|
|||
In the Excel spreadsheet, the first row was the field labels (First Name,
Last Name, etc.). I no longer use that document, by the way. I imported the data into an Access database, so the data now comes from a select query that is linked to the main merge document. But merging from either datasource produced the same problem. "Graham Mayor" wrote: Does your data file use the first record as a header? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org TS in FL wrote: I am using Word 2002. After I merge a letter from either Excel or Access, my first record is missing from the merged document, i.e., if I tell it to merge records 1 through 10, the merged document contains letters for records 2 through 10. This occurs whether I use the edit mail merge recipients list, and only check records 1 thru 10, or whether I select "merge to new document" on the toolbar and tell it to merge from 1 to 10. BTW, there are no NEXT or NEXT RECORD fields in the main document. Why is this?? |
#4
|
|||
|
|||
Hi =?Utf-8?B?VFMgaW4gRkw=?=,
I am using Word 2002. After I merge a letter from either Excel or Access, my first record is missing from the merged document, i.e., if I tell it to merge records 1 through 10, the merged document contains letters for records 2 through 10. This occurs whether I use the edit mail merge recipients list, and only check records 1 thru 10, or whether I select "merge to new document" on the toolbar and tell it to merge from 1 to 10. And if you let it merge ALL records? Are you able to VIEW the first record in the main merge document? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
data in mail merge letter being cut off - data source field size? | tgone | Mailmerge | 1 | May 20th, 2005 02:10 PM |
Multiple merge with IncludeText generating extraneous hidden c | Judy | Mailmerge | 2 | May 5th, 2005 03:51 PM |
Mail merge option with multiple data source records in one letter. | E Weij | Mailmerge | 1 | April 18th, 2005 02:24 PM |
Restrict records that match date criteria at merge time | Peter Wilde | Mailmerge | 1 | May 5th, 2004 08:40 AM |
Word 2003 is adding duplicate records to my mail merge | Doug Robbins - Word MVP | Mailmerge | 0 | April 24th, 2004 03:58 AM |