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.
|