Multiple records into a single document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 17 Mar 2005 09:51 GMT

In Office 97 I could create a standard letter and then merge it with multiple
records to a separate document, thus maintaining the integrity of the
standard letter.

In Office 2003
(a)it refuses to merge with multiple records. The only way I can do this is
to copy the letter and paste to new pages with the 2nd and subsequent copies
prefixed by "next record". I have to do this for as many times as there are
records in the data source which is just about bearable for 10-20 records but
unacceptable for 100.

(b) not only that but it then does not offer the option of merging to a
separate document so I end up corrupting my original standard letter.

Please can you help me at all?

Many thanks for your time.

Mark

Reply to this Message

For - 17 Mar 2005 13:59 GMT

It is the same question I want to know. I would like to know how multiple
records prepared in Excel file can be printed in Word file within one page,
and then multiple records in second page.
Thanks
For

> In Office 97 I could create a standard letter and then merge it with multiple
> records to a separate document, thus maintaining the integrity of the
[quoted text clipped - 15 lines]
>
> Mark

Reply to this Message

Doug Robbins - 17 Mar 2005 20:11 GMT

It is not the same question, but use a catalog (or in Word XP and later, a
directory) type of mailmerge main document.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> It is the same question I want to know. I would like to know how multiple
> records prepared in Excel file can be printed in Word file within one
[quoted text clipped - 27 lines]
>>
>> Mark

Reply to this Message

For - 18 Mar 2005 12:37 GMT

May be my question is not so clear. I want to know how to do the compound
merge.

> It is not the same question, but use a catalog (or in Word XP and later, a
> directory) type of mailmerge main document.
[quoted text clipped - 30 lines]
> >>
> >> Mark

Reply to this Message

Doug Robbins - 17 Mar 2005 20:09 GMT

I suspect that you are not actually executing the merge.

Probably best if you dispense with the Wizard and do one of the following:

1. From the View menu, select Toolbars and then check the Mailmerge item.
This will display the Mailmerge toolbar that contains buttons that allows
you to perform the whole mailmerge process, including buttons at the right
hand end of the toolbar for merging to various destinations.

2. From the Tools menu, select Customize and in the Commands tab of the
Customize dialog, select the All Commands category and in the list of
commands, locate the Mailmerge Helper item and click and drag it onto a
toolbar. This will give you back the original interface with which you are
used to working.

Signature

> In Office 97 I could create a standard letter and then merge it with
> multiple
[quoted text clipped - 20 lines]
>
> Mark

Reply to this Message

Chris - 22 Mar 2005 20:52 GMT

It sounds like mail merge may not be your best option. If you add the
Database toolbar to your workspace and insert a database you can get a
lot of rows of data from all the same sources the mail merge uses. You
can select the option to make the data dynamic so that it refreshes when
its source refreshes.

Does that help?

Chris Weber

> In Office 97 I could create a standard letter and then merge it with multiple
> records to a separate document, thus maintaining the integrity of the
[quoted text clipped - 15 lines]
>
> Mark

Reply to this Message