Mail merge from one data soure to a number of different main doc?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

suew1231 - 14 Nov 2004 17:52 GMT

I am trying to mail merge a number of different letters from one excel
spreadsheet.
The problem being: If I Copy and paste each doc needed to form one lengthy
doc. and mail merge from excel it dosen't change per page. I need each page
to reflect a different line from the spreadsheet. Is there any way of doing
this besides to brake up the spreadsheet?

Reply to this Message

Doug Robbins - 15 Nov 2004 01:59 GMT

Insert a Next Record field at the point where you want the merge to make use
of the next record.

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

>I am trying to mail merge a number of different letters from one excel
> spreadsheet.
[quoted text clipped - 4 lines]
> doing
> this besides to brake up the spreadsheet?

Reply to this Message

sue_w1231 - 15 Nov 2004 15:20 GMT

Doug: The Word 2003 file has 16 different mail merge letters with each
letter identified with a different letter type code. The Excel 2003 file has
data listed on 60 individuals. One column in this Excel file shows the
letter type code to be used for each individual's letter.

We are trying to figure out how to merge the Excel individual data to the
correct Word letter type in one mail merge function.

Letter type "E1" for example does not have an individual in the Excel data
file with a letter type code "E1" so there would be no records to merge into
the "E1" letter; however, there are 2 individuals that should be merging into
the "E2" letter, etc.

We tried the Insert Word Field "Next Record If" Letter equal to E2, and
tried the "Skip Record If" Letter not equal to E2, but neither one is
working.

It will take the first name on the Excel file which has a letter type ID of
"C10" and merge this data into all 16 different letter types, and then go to
the next record and merge that data into all 16 deifferent letter types.

What are we not doing correctly?

> Insert a Next Record field at the point where you want the merge to make use
> of the next record.
[quoted text clipped - 7 lines]
> > doing
> > this besides to brake up the spreadsheet?

Reply to this Message

Doug Robbins - 16 Nov 2004 01:02 GMT

Later non-threaded post answered.

Signature

> Doug: The Word 2003 file has 16 different mail merge letters with each
> letter identified with a different letter type code. The Excel 2003 file
[quoted text clipped - 37 lines]
>> > doing
>> > this besides to brake up the spreadsheet?

Reply to this Message