mergeing data from access 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete - 11 Oct 2003 05:00 GMT

Hi
I want to merge an access query of more than 150 records
into Word 2000 but I want to list 4 records per a4 page.

The word document has areas where I normally would fill
out new customer details by hand.I have existing
customers in the database and want to list their contact
information in the word doc.

I have set up text boxes with the merge links in the
areas I want in the doc however when I merge I get the
same record 4 times on a page when I want 4 different
records.

Can anyone help me with how to do this?
Cheers Pete

Reply to this Message

Peter Jamieson - 11 Oct 2003 18:42 GMT

You need a { NEXT } (<<Next record>>) field before the layout for each of
records 2,3, and 4.

--
Peter Jamieson
MS Word MVP

> Hi
> I want to merge an access query of more than 150 records
[quoted text clipped - 12 lines]
> Can anyone help me with how to do this?
> Cheers Pete

Reply to this Message

Pete - 13 Oct 2003 05:27 GMT

Hi Peter
I tried to use a text box with (Next Record)field
inserted before each record. When I go to merge I get the
following error message:
"You cannot include DATA, NEXT, NEXTIF, or SKIPIF fields
in comments, comma headers,comma footers, comma footnotes
or end notes."

Any ideas?
Pete

>-----Original Message-----
>You need a { NEXT } (<<Next record>>) field before the layout for each of
[quoted text clipped - 22 lines]
>
>.

Reply to this Message

Peter Jamieson - 13 Oct 2003 08:50 GMT

Yes, sorry, I hadn't noticed that you were using text boxes. A number of
field types won't work in text boxes so you need to find a different way to
lay out your page. I would suggest
a. convert your text boxes to /frames/ (select the text box, right-click,
select Format Text BoxText Box|Convert to Frame). However, you may still
find that the sequence of records is not what you want, in which case you
may need to move the frames around so you get the correct sequence (or
explicitly anchor them to successive paragraphs in the sequence you want).
b. a 2x2 table (but the records may not appear in the sequence you want
c. a 2-column document with 2 1-column, 2-row tables

If you find you need to work with frames a lot, you should find the Insert
frame command
(Tools|Customize|Commands, select All Commands in the Categories column and
locate Insertframe in the right hand column and drag it to a toolbar or
menu.)

--
Peter Jamieson
MS Word MVP

> Hi Peter
> I tried to use a text box with (Next Record)field
[quoted text clipped - 37 lines]
> >
> >.

Reply to this Message

Pete - 13 Oct 2003 05:53 GMT

Hi Peter
I typed in the { NEXT } (<<Next record>>) field before
each layout as you suggested however when I merged to a
new document the last record appeared consecutively for
each of the 4 records per page.

Any ideas?
Peter

>-----Original Message-----
>You need a { NEXT } (<<Next record>>) field before the layout for each of
[quoted text clipped - 22 lines]
>
>.

Reply to this Message