More help needed with Mail Merge.

[Chris Mitchell]

Using MS Word and Excel 2002 SP3.



How can I make different sections of my Mail Merge Word document look at
different Worksheets within the same Excel Spreadsheet for data for the
various sections?



I've completed the first section, but can't see how select a different
worksheet within the same workbook for the next section of my document.

 

[Arvi Laanemets]

Hi

You can't. Create a master sheet, where all needed data is consolidated into
a single table through links - a row for a document - and use this as source
table.

 

[Peter Jamieson]

You can't, really. A mail merge can only have one data source. IN this case,
your best bet is /probably/ to create a separate Word document for each
section, merge each one to a new document, and combine them into a single
document. If you do that, make sure that you do not create different
character or paragraph styles wwith the same names in the different
documents or there will be problems when you compose the complete document.

 

[Chris Mitchell]

Can't.

Table would be too big for Excel to handle.

 

[Arvi Laanemets]

Hi

Can't.

Table would be too big for Excel to handle.

Too much columns or what?

When yes, then maybe you can consolidate several fields from source tables
into single field in master table - i.e. you generate some text sections in
master table fields instead of merge document.

 

[Chris Mitchell]

Thanks.

Just finished creating sepaerate documents as suugested.