I am creating a form letter in Word, with an Excel file as the source. I am
able to merge the file fine, except there is once cell that is not in the
Merge Data Range, that I want in each document. How do you insert a single
cell from an Excel file into a word document?
NOTE: The cell I want to add in is a formula, which is why i simply can't
type it in the document.
Hope this is clear. Thank you.

The thing to do is to include the column in which that cell is located in
the datarange. Is there any reason that you cannot do that?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"MATT" wrote in message
...
I am creating a form letter in Word, with an Excel file as the source. I
am
able to merge the file fine, except there is once cell that is not in the
Merge Data Range, that I want in each document. How do you insert a
single
cell from an Excel file into a word document?
NOTE: The cell I want to add in is a formula, which is why i simply can't
type it in the document.
Hope this is clear. Thank you.

Well, 2 things: 1)If I have say 10 records, and include this data as its own
column in the range, it is only 1 or 2 records long, it will insert blank at
the 3rd record (correct? I would need it to repeat that cell at each record?)
Also, the records may change fairly often, and already consist of many
columns.
What i am looking to do is: Header row and data are rows C through Z.
There is data in Cell A1 and B1 that I would like on each letter. So, I
would like to Merge rows c - z into the word Doc, and insert(?) Cells A1 and
B1.

"Doug Robbins" wrote:

The thing to do is to include the column in which that cell is located in
the datarange. Is there any reason that you cannot do that?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"MATT" wrote in message
...
I am creating a form letter in Word, with an Excel file as the source. I
am
able to merge the file fine, except there is once cell that is not in the
Merge Data Range, that I want in each document. How do you insert a
single
cell from an Excel file into a word document?
NOTE: The cell I want to add in is a formula, which is why i simply can't
type it in the document.
Hope this is clear. Thank you.

You need to repeat that data for each record. A simple copy past
(click-drag) operation in Excel.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"MATT" wrote in message
news
Well, 2 things: 1)If I have say 10 records, and include this data as its
own
column in the range, it is only 1 or 2 records long, it will insert blank
at
the 3rd record (correct? I would need it to repeat that cell at each
record?)
Also, the records may change fairly often, and already consist of many
columns.
What i am looking to do is: Header row and data are rows C through Z.
There is data in Cell A1 and B1 that I would like on each letter. So, I
would like to Merge rows c - z into the word Doc, and insert(?) Cells A1
and
B1.

"Doug Robbins" wrote:

The thing to do is to include the column in which that cell is located in
the datarange. Is there any reason that you cannot do that?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a
paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"MATT" wrote in message
...
I am creating a form letter in Word, with an Excel file as the source.
I
am
able to merge the file fine, except there is once cell that is not in
the
Merge Data Range, that I want in each document. How do you insert a
single
cell from an Excel file into a word document?
NOTE: The cell I want to add in is a formula, which is why i simply
can't
type it in the document.
Hope this is clear. Thank you.