Home |
Search |
Today's Posts |
#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 ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
skipped mail merge records | Mailmerge | |||
Mail merge option with multiple data source records in one letter. | Mailmerge | |||
e-mail merge different records to group of individuals? | Mailmerge | |||
Merged data that is present in data source is missing in merge | Mailmerge | |||
Merge Multiple Records into One Document | Mailmerge |