MailMerge -Named Ranges in Excel??

[mjbosko]

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

 

[01Patrik]

If your data is structured like a database - with one post per customer, but several datafields, eg

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

etc where "|" is the column/cell break, then this isn't a problem.

Using MS Word 2002 or later, you use tools - Letters and ... - mail merge. Word 2000: Tools - Mail merge.

Follow the instructions! Shouldn't be a problem, if you prefer, use the toolbox "Mail merge".

// Patrik