Re: merge directory type doc with excel data source

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I inserted one set of Merge Fields in the mail merge main document and nother
else but the merge resulted in one record on each page and not all records on
one page. Do you have any other suggestions?
--
Laura


"Doug Robbins - Word MVP" wrote:

For a Directory type mail merge, just insert one set of Merge Fields in the
mail merge main document and nothing else. When you execute that merge, you
will get the desired result.

If you want the data to appear in a table, insert a one row table into the
main document and insert the fields into the cells of that table. If the
fields are not in a table, you will need an empty paragraph after the the
paragraph containing the merge fields so that the data for each record is in
a separate paragraph in the document produced by executing the merge.

--
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

"Laura" <Laura@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42F10196-6B2C-4560-AEE5-EAAE8E2B76AA@xxxxxxxxxxxxxxxx
I am using Word 2007 and Exel 2007. Using mail merge wizard, I choose
directory as type of document and select recipients which are in Excel
with
column headings. I select the merge fields name and address. I want
several
name and address records to appear on one page. If I insert merge fields
until I fill the page, it prints the first record several times on page 1,
then prints the second record serveral times on page 2, etc.

If I insert Next Record field before the name merge field beginning with
the
second record of name and address and continue inserting merge fields
preceded by Next Record field until I fill the page, it prints all the
records on page 1 but continues printing additional pages beginning with
the
second record of the previous page. For example, if there are 5 records,
page 1 lists 5 records, page 2 lists 4 records, page 3 lists 3 records
etc.

How do I get the mail merge to only print the 5 records on one page?
--
Laura



.

Relevant Pages

  • Re: merge directory type doc with excel data source
    ... Your reply "execute the merge, does the document that is produced have the ... fields are not in a table, you will need an empty paragraph after the the ... then prints the second record serveral times on page 2, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: the rich are doing OK thank god!!
    ... So, by your own statement, laws are changed. ... by inserting `at least' before ... by redesignating paragraph as paragraph; ... by striking `10 years' and inserting `a ...
    (rec.boats)
  • Re: Multi line numbering formatting (usage multiline headings)
    ... I also had to base the TOC 1 style on say ... The reason is that inserting a carriage ... return inserts a paragraph in Word. ... >>> after that follows what ever I title the heading. ...
    (microsoft.public.word.docmanagement)
  • Re: Inserting pictures, pictures cluster when typing
    ... To try, I made a series of pages, wrote a paragraph on each one, then ... copy/pasted the pictures in. ... Don @ Black Dog Architects ... inserting page breaks without first inserting new paragraphs, ...
    (microsoft.public.word.docmanagement)
  • Re: insert a table bwtween a series of tables
    ... Turn on the display of paragraph marks. ... inserting the AutoText. ... Margaret Aldis - Microsoft Word MVP ... Syntagma partnership site: http://www.syntagma.co.uk ...
    (microsoft.public.word.tables)