Re: Mail merge dropping records

From: Doug Robbins - Word MVP (dkr_at_NOmvpsSPAM.org)
Date: 05/12/04 

Date: Thu, 13 May 2004 09:00:56 +1000

Are you sure that you do not have a <<Next Record>> field after the last set
of merge fields on the page?

You should use either a label or a catalog (or in Word XP/2003 a directory
type) mailmerge main document. In the latter you would just use one set of
merge fields. If you want to force it to only insert 5 records per page,
arrange those fields inside a single cell table that has the cell dimensions
fixed so that only five of them will fit on a page. 

-- 
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
"Jan" <anonymous@discussions.microsoft.com> wrote in message
news:bfb401c4382f$69b1e0e0$a601280a@phx.gbl...
> I have a form with merge fields for first name, last name,
> SSN, DOB, that I want to merge with a database of about
> 100 records. There are five records per page. It merges
> fine but drops every fifth record when I merge the entire
> database.  I deleted the "next record" code on the first
> entry which solved the dropping the first record problem
> but did not solve dropping the others.  Any idea?

Relevant Pages

  • Re: How to import certain fields from access database?
    ... my suggestion of using a combobox was make because it is a more certain way ... "Access a database and insert into a Word document the data that you find ... Doug Robbins - Word MVP ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to import certain fields from access database?
    ... thanks but i wanted to use the combobox on form so that the user can find the ... "Access a database and insert into a Word document the data that you find ... Doug Robbins - Word MVP ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Populating a list box from a database
    ... Doug Robbins - Word MVP ... >> my access database to populate a 'combo box'. ... ' Load the ListBox with the retrieved records ... >>> Doug Robbins - Word MVP ...
    (microsoft.public.word.vba.general)
  • Re: Positioning Data in Indivisual Cells within a Table using VBA
    ... Doug Robbins - Word MVP ... Dim myDataBase As Database ... Dim myActiveRecord As Recordset ... Set drow = dtable.Rows.Add ...
    (microsoft.public.word.tables)
  • Re: How to import certain fields from access database?
    ... my suggestion of using a combobox was make because it is a more certain way ... "Access a database and insert into a Word document the data that you find ... Doug Robbins - Word MVP ... Dim myActiveRecord As Recordset ...
    (microsoft.public.word.mailmerge.fields)