MailMerge Range?

[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

 

[Arvi Laanemets]

Hi

You can use MS Word Mail Merge with an Excel table as datasource.

In your Excel table all info for one document (mail) MUST BE ON SINGLE
ROW!!! The table MUST have an header row! It's easier, when the source table
is on first sheet of workbook.

So your table will look something like
Customer MailAddress Field1_1 Field1_2 Field2_1 Field2_2
....
Customer1 (e-mail address removed) Data1 Data4 Data2 Data5
....

You open word, start Mail Merge, create a main document, and select your
Excel table as datasource (you have to change the file type!). Now you can
edit the main document - inserting merge fields (column headers) into your
text at appropriate positions.

When the main document is ready, you press Merge button - now is opened the
window where you can set to where you are sending the output (and you can
set filters to source table too). Select 'Mail letter' as output, and press
Merge button again. You are asked for field (column) which contains mail
address. Insert it, and finish. I'm not sure, but better open your mail
program (Outlook) before it - possibly mail merge uses it. For every row in
source table a mail is sent.


Arvi Laanemets

 

[Wapiti]

I know how to do a simple mail merge like this, but my example doesn't have
all data in one row. Thats why I'm wanting to use a named range.

Can someone please verify that this truly cannot be done?

Thank you,

-m

 

[Earl Kiosterud]

Wapiti,

All the data to be used in each document the mail merge generates must be in
a single row. One record (row) per document. A named range won't help you.

 

[David McRitchie]

Hi Mike,
To help you put your data on one row per mailing address
see http://www.mvps.org/dmcritchie/excel/snakecol.htm

For help with Mail Merge labels
http://www.mvps.org/dmcritchie/excel/mailmerg.htm