how do i set up a list of customers in excell for mail merge
 

I am looking to set up a data base of 100 customers. I need to be able to
pull the data from the spreed sheet to make lables and to do a mail merge
letter. What would be the best way to set that up useing word and excell

Create mailing labels by merging an address list
Step 1: Create the main document
Click New Blank Document on the Standard toolbar.


On the Tools menu, click Mail Merge.


Under Main document, click Create, and then click Mailing Labels.


Click Active Window.
The active document becomes the main document.

Step 2: Open or create the data source
In the Mail Merge Helper dialog box, do one of the following:
Create a new data source. Use this method if you haven't already stored
names, addresses, and other data in a data source, and you want to store the
data in a Microsoft Word table.


Use data in an existing data source. Under Data source, click Get Data, and
then click Open Data Source. Select a Word document, or a worksheet,
database, or other list, and then click Open. Click Set Up Main Document.


Use addresses from an electronic address book. Under Data source, click Get
Data, and then click Use Address Book. Select an address book, and then click
OK. Click Set Up Main Document.

"Redford" wrote:

I am looking to set up a data base of 100 customers. I need to be able to
pull the data from the spreed sheet to make lables and to do a mail merge
letter. What would be the best way to set that up useing word and excell

Thanks JR. I can not find a mail merge function in the drop down tool bar in
excell. Only in Word

"JR" wrote:

Create mailing labels by merging an address list
Step 1: Create the main document
Click New Blank Document on the Standard toolbar.


On the Tools menu, click Mail Merge.


Under Main document, click Create, and then click Mailing Labels.


Click Active Window.
The active document becomes the main document.

Step 2: Open or create the data source
In the Mail Merge Helper dialog box, do one of the following:
Create a new data source. Use this method if you haven't already stored
names, addresses, and other data in a data source, and you want to store the
data in a Microsoft Word table.


Use data in an existing data source. Under Data source, click Get Data, and
then click Open Data Source. Select a Word document, or a worksheet,
database, or other list, and then click Open. Click Set Up Main Document.


Use addresses from an electronic address book. Under Data source, click Get
Data, and then click Use Address Book. Select an address book, and then click
OK. Click Set Up Main Document.

"Redford" wrote:

I am looking to set up a data base of 100 customers. I need to be able to
pull the data from the spreed sheet to make lables and to do a mail merge
letter. What would be the best way to set that up useing word and excell

Redford,

Your Excel list should have one row per employee, and a heading row at the
top. The Word mail merge needs that standard table layout. The details of
doing the mail merge are in another reply, and other places.
--
Earl Kiosterud
www.smokeylake.

"Redford" wrote in message
...
I am looking to set up a data base of 100 customers. I need to be able to
pull the data from the spreed sheet to make lables and to do a mail merge
letter. What would be the best way to set that up useing word and excell