Merge excel ranges to customer letters??

[Wapiti]

MSoffice 2000

We have an excel spreadsheet that shows us information about our clients.
The data is displayed in blocks, that can easily be given a named range.

We want to send a letter (msword) to each of our customers and display the
data in these blocks (from excel).

How can this be done?

For example...

Excel contains data similar to the following, and each section could be a
named range:

| Colhdr| Colhdr| Colhdr
CUSTOMER1 | Data1 | Data2 | Data3
| Data4 | Data5 | Data6

| Colhdr| Colhdr| Colhdr
CUSTOMER2 | Data1 | Data2 | Data3
| Data4 | Data5 | Data6

| Colhdr| Colhdr| Colhdr
CUSTOMER3 | Data1 | Data2 | Data3
| Data4 | Data5 | Data6


We'd like to have our mail merge letters specific to each customer and
simply display the data directly from each customer in the letter.

--------------------------------------------------------------------------

Dear CUSTOMER1
Here is the data we have for you:

| Colhdr| Colhdr| Colhdr
CUSTOMER1 | Data1 | Data2 | Data3
| Data4 | Data5 | Data6
Thank you.

--------------------------------------------------------------------------

Dear CUSTOMER2
Here is the data we have for you:

| Colhdr| Colhdr| Colhdr
CUSTOMER2 | Data1 | Data2 | Data3
| Data4 | Data5 | Data6
Thank you.

--------------------------------------------------------------------------

Dear CUSTOMER3
Here is the data we have for you:

| Colhdr| Colhdr| Colhdr
CUSTOMER3 | Data1 | Data2 | Data3
| Data4 | Data5 | Data6
Thank you.

--------------------------------------------------------------------------

Can this be done???

Thanks,

Mike

 

[Cindy M -WordMVP-]

Hi Wapiti,

I'm afraid mail merge can't handle this setup. Mail merge requires a table
layout for the data: each record across a single row; the fields in columns.

You'd need a macro in Excel to copy this data to a layout acceptable to Word

Customer1|Data1|Data2|Data3|Data4|Data5|Data6

We want to send a letter (msword) to each of our customers and display the
data in these blocks (from excel).

How can this be done?

For example...

Excel contains data similar to the following, and each section could be a
named range:

| Colhdr| Colhdr| Colhdr
CUSTOMER1 | Data1 | Data2 | Data3
| Data4 | Data5 | Data6

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail