Merge With Excel

[MATT]

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.

 

[Doug Robbins]

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]

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]

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