Mail Merge with Excel Auto Subtotal List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allison - 05 Oct 2004 18:33 GMT

I am attempting to merge an Excel List (from a Quickbooks
report) into a Word Main Doc. I have auto summed the
records to get a subtotal which is the amount that I want
in each letter in Word.

When I perform the Merge, I get letters for each record
rather than just the subtotal (I am viewing the 2 level in
the outline in Excel, so the individual record amounts are
not showing).

How can I get only one letter per customer? Thanks
Allison

Reply to this Message

Doug Robbins - 06 Oct 2004 00:39 GMT

The data source of a mailmerge in Word must be a "flat" file.

If you have Access, copy and paste the spreadsheet data as a table in
Access, then use a Query to group the records by customer and do the
summation for each. Then use that Query as a data source.

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 attempting to merge an Excel List (from a Quickbooks
> report) into a Word Main Doc. I have auto summed the
[quoted text clipped - 8 lines]
> How can I get only one letter per customer? Thanks
> Allison

Reply to this Message