A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

First Record's Letter Missing after Letter Merge



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2005, 12:49 AM
TS in FL
external usenet poster
 
Posts: n/a
Default 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  
Old June 7th, 2005, 04:13 AM
Graham Mayor
external usenet poster
 
Posts: n/a
Default

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  
Old June 7th, 2005, 06:01 AM
TS in FL
external usenet poster
 
Posts: n/a
Default

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  
Old June 8th, 2005, 01:15 PM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 11:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.