Hello ****.

I have a similar question.

I have a table too, but i dont want to write a paragraph in Word. I want
this in Excel sheets.

I have two columns (Customer name and Customer productivity) in my table.
And about 200 rows.

I have a text that will be sent to my customers every week, the text is same
for all customers but in it there is a place that differs;

Customer Name: (This will be taken from table)
Customer productivity: (This will be taken from table).

And for each customer, a new sheet will be created.

For ex;

Customer name Customer Productivity
John 75
Alla 55
Adam 90
Kate 50
.... ...........
......... ............

So goes on.

And my text will be like;

Hello, this is your performance.

Customer name: John
Customer productivity: 75

And the worksheet in excel workbook must be named as John. And this must be
done till the last customer.

If it is not possible, or not easy, this can be sent to a Word Document and
each document again must have the name of the customer.

Thanx...

"**** Kusleika" wrote:

> Arun
>
> This is the technique I use:
>
> http://www.*****-blog.com/archives/2...tomating-word/
>
>
> --
> **** Kusleika
> Excel MVP
> Daily Dose of Excel
> www.*****-blog.com
>
> Arun wrote:
> > I've Invoice Data in Excel and I would like to create a word document
> > when I press Create Invoice button of shortcut key.
> >
> > I'm able to create a word application and open a new document and
> > start filling in the data. However, I want to use a Word Template and
> > fill in the data at specific location. like Invoice No. in the Table
> > Cell at Top Right Corner and Invoice Date 1 Cell below, etc.
> >
> > What is the best approach, I definitely do not want to use mail
> > merge. I currently use mail merge.
> >
> > Thanks in Advance
>
>
>