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.