Reply
 
Thread Tools Display Modes
  #1   Report Post  
MATT
 
Posts: n/a
Default Merge With Excel

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.
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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.



  #3   Report Post  
MATT
 
Posts: n/a
Default

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.




  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

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.






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I merge an excel document Pat McGlamery Tables 1 December 10th 04 04:00 AM
merge with excel question Cowtoon Mailmerge 1 December 7th 04 11:51 AM
Merge from Excel to word for labels pattimelt Mailmerge 1 December 5th 04 11:44 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 11:46 PM
how do i create a mail merge for email using excel as a data sourc AnnA Mailmerge 1 December 1st 04 01:57 AM


All times are GMT +1. The time now is 10:40 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"